Combine 5 Pivot Tables into 1 Pivot Table

[excel?]

I have data in 5 tabs in my spreadsheet and have created a Pivot Table from each tab. Now I want to combine the 5 Pivot Tables into 1 consolidated Pivot Table.

How can I do this?

Each Pivot Table is for a different Plant and contains Product Codes and its Quantity. I would like a single Pivot Table that combines all the data showing the Product Codes and the Quantity for each Plant.

Here is an example of 2 of my pivot tables:

Plant 1
84134 1,254
84225 357
85597 2,101

Plant 2
84134 3,475
84336 1,986
85597 1,665

And I would like something like this:

84134
Plant 1 1,254
Plant 2 3,475
84225
Plant 1 357
84336
Plant 2 1,986
85597
Plant 1 2,101
Plant 2 1,665

Any suggestions would be greatly appreciated.

Thank you.

 

[excel?]

Any one have any ideas I can try? I keep hitting road blocks and could use some advice. Thanks

 

[sandy666]

You can try consolidate sources of existing PivotTables into single PT via Alt+D+P

 

[excel?]

Thank you for this. It took some manipulating but it has really helped.

Really appreciate the support. Thx

 

[sandy666]

You are welcome

Have a nice day