Append data in multiple sheets into one sheet

Please help! I think I'm loosing it trying to figure this out.
I have a workbook with multiple worksheets. All worksheets have same column headers, but no common information. I want to append/consolidate all this information.
For example

HTML Code: 

Sorry, these are in html tags to keep the formatting.
The idea is to have a pivot table that summarizes this data with report filter field 'requestor'.
Both Sheet 1 and 2 will be updated constantly, so I want the summary sheet to be updated automatically as well so the pivot table provides latest info everytime it is refreshed. There are several othere columns of data that I want the pivot table to ignore.
Please help me think through this.
I tried using MS_query, but am not knowledgable enough to know how to pull data from both tables together when the data in each table is different.
Thanks for your help.

Thanks for the help, guys! U'll are my heroes!

Hi excel_vb

I have no idea where I found this code. I typically attribute it but the code appears to do what you described. I've attached a workbook that you can play with to see how it works.

Please Login or Register  to view this content.

Let me know of issues you have adapting it to your needs.
John

Here's a few little twists on Jaslake's macro...

This will continue if the Master sheet already exists, it will simply reset it and make sure it's at the end of the workbook, else it will create it.

I also took out the Excel 2003-specific row references... minor stuff.

Please Login or Register  to view this content.