Sub klkl()
Sheet1.Range("a1").CurrentRegion.Offset(1).ClearContents
For Each sht In Worksheets
If sht.Name <> "汇总" Then
last_row = Sheet1.Cells(Rows.Count, 1).End(3).Row + 1
irow = sht.Cells(Rows.Count, 1).End(3).Row
sht.Range("a2:L" & irow).Copy
Sheet1.Range("a" & last_row).PasteSpecial xlPasteValues
End If
Next
End Sub