Copying data from multiple worksheets to a master worksheet

Hi, I'm a beginner at Excel, so please bear with me.

I have a workbook with multiple worksheets. Each worksheet is a set o data from a certain year. I want to create a macro that automatically copies the data from these worksheets into a master worksheet that can easily be used to make a pivot table. How can I do this? (I included a sample workbook in the attachments.)

If every sheet has the exact same column headers, all the data is already in the correct place and you just want "Summary" report created, then this basic macro does that:

Please Login or Register  to view this content.

Run the SummaryReport macro (press Alt-F8)

If you run it successively, it erases the existing report and creates a new one.

If you don't want the old report erased but want new data appended to the bottom of the existing report, comment out or erase the "optional" line of code in the macro.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

jmrendel. Welcome to the forum. Unfortunately:

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.