Help with Macro to dump multiple sheets into one master sheet linked to Pivot Table

Greetings!

Please see my attached workbook. I am looking for assistance in creating a Macro that will grab all the data from the 'JulAugSep', 'OctNovDec', 'JanFebMar', and 'AprMayJune' sheets and dump it into 'Linked Sheet' starting at cell A2. Excel's consolidation option doesn't seem like the right solution because I'm not trying to sum, average etc the data; I'm simply trying to get everything from the Quarterly sheets into the Linked sheet, from which my Pivot table is linked to.

I've also tried, but have been unsuccessful at using the Pivot Table/Chart Wizard using Multiple Consolidation ranges to create a Pivot Table that incorporates all the quarterly data. I can articulate more on this if need-be.

Thank you.

Rick

Hi PCI.

Whoops! My bad- The Linked Sheet should have been left empty; I forgot to delete that out of there. So yes, we are presuming the Linked Sheet is empty when we are running the macro.

Thank you.

Worked like a charm! Thank you so much! Now, if I want to have the data paste into the Linked Sheet starting at cell A2 (in order to keep the headers in tact), do I change .Range("A1:A" to .Range("A2:A" ?

I can't express my gratitude enough for your help! Thank you!