Sub lala() Dim sht As Worksheet, endrow As Long For Each sht In Worksheets endrow = Worksheets("汇总").Range("a65536").End(xlUp).Row + 1 If sht.Name <> "汇总" Then sht.[a1].CurrentRegion.Copy Worksheets("汇总").Cells(endrow, 1) End If Next sht End Sub
Sub lala() Dim sht As Worksheet, endrow As Long For Each sht In Worksheets endrow = Worksheets("汇总").Range("a65536").End(xlUp).Row + 1 If sht.Name <> "汇总" Then sht.[a1].CurrentRegion.Copy Worksheets("汇总").Cells(endrow, 1) End If Next sht End Sub