Sub 多表合并3()
Dim RMax As Integer, CMax As Integer
Dim sht As Worksheet, ShtR As Integer
For Each sht In Worksheets
If sht.Name = "汇总" Then Worksheets("汇总").Cells.Delete
GoSub 100
Next sht
Sheets.Add.Name = "汇总"
100:
For Each sht In Worksheets
If sht.Name <> "汇总" Then
With sht.Range("A1")
ShtR = Sheets("汇总").UsedRange.Rows.Count
RMax = .End(4).Row - 1
CMax = .End(2).Column
If ShtR = 1 Then .EntireRow.Copy Sheets("汇总").Cells(ShtR)
.Offset(1).Resize(RMax, CMax).Copy Sheets("汇总").Cells(ShtR + 1, 1)
End With
End If
Next sht
Sheets("汇总").Cells.EntireColumn.AutoFit
End Sub