Consolidating Multiple Tabs of Data

Hi,

I have multiple tabs with identical 1st row column labels. Each has varying number of rows. How can I combine each tab into one master worksheet?

I want each subsequent tab brought in immediately following the preceeding tab's final row. The consolidate feature in Excel isn't allowing me to do this, but rather wants to aggregate a given row from each tab into one row.

there you go, hope it works the way you want, let me know if it doesn't
the code will create a sheet named master, you should start only with the sheets that you want consolidated since it will loop through all sheets, if you have sheets that you don't want consolidated then you will have to change the "for s =" line

Please Login or Register  to view this content.