Sub main() Dim mySheet As Worksheet Dim tmpSheet As Worksheet Dim R As Integer, C As Integer R = 1 Set mySheet = ThisWorkbook.Worksheets.Add() mySheet.Name = "汇总" For Each tmpSheet In ThisWorkbook.Worksheets With tmpSheet If .Name <> "汇总" Then For C = 1 To 6 mySheet.Cells(R, C) = .Cells(1, C) Next mySheet.Cells(R, C) = .Name R = R + 1 End If End With Next End Sub '如果你已经建好了“汇总”表,请先删除之。