Dim wb As Workbook, sht As Worksheet, sh As Worksheet, i%, j%, k%, m%, n%
Dim CopyRng
Set wb = ThisWorkbook
For Each sh In wb.Sheets
If sh.Name <> "汇总" Then
m = sh.Range("b65536").End(xlUp).Row
With sh
Set CopyRng = Union(.Range("A" & 14 & ":c" & m), .Range("q" & 14 & ":q" & m))
End With
With Sheets("汇总")
CopyRng.Copy.["a" & .[a265536].End(3).Row + 1]
End With
End If
Next
End Sub