Combine worksheet with same type of data set

[billisnice]

I get a report with 3 worksheets with the same headers and different info. I have been copy/cut to combine to sheet 1 making one long data set -one on top of the other. Is there a faster way to combine the 3 sheets in the same workbook?

[CK76]

Try something like below. Assuming headers in row1, data starts at A2 and no empty rows/columns. And data combined in same workbook (though I'd usually recommend creating master workbook, where data are collected).

Please Login or Register  to view this content.