If you have multiple sheets with the same columns and want to stack them one under another, the function is the fastest dynamic method. How to do it: Create a new sheet for your combined data.
For Each ws In ThisWorkbook.Worksheets If ws.Name <> destWs.Name Then lastRow = destWs.Cells(destWs.Rows.Count, 1).End(xlUp).Row + 1 ws.UsedRange.Copy destWs.Cells(lastRow, 1) End If Next ws how to merge excel sheets