Bạn cho chạy thử code sau (tham khảo trên diễn đàn) xem thế nào nhé:
Sub Copy()
Const shTotal = "Total"
Dim wb As Workbook, iRow As Long
Dim sTotal As Worksheet, sh As Worksheet
Application.ScreenUpdating = False
Set wb = ActiveWorkbook
iRow = 1
On Error Resume Next
Set sTotal = wb.Sheets(shTotal)
Set sTotal = ActiveSheet
For Each sh In wb.Sheets
If sh.Name <> shTotal Then
With sh.UsedRange
.Copy Destination:=sTotal.Cells(iRow, 1)
iRow = sTotal.UsedRange.Rows.Count + 1
End With
End If
Next
Application.ScreenUpdating = True
End Sub