ExcelBanter - how do I consolidate multiple pivot tables into one pivot table?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I consolidate multiple pivot tables into one pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/84315-how-do-i-consolidate-multiple-pivot-tables-into-one-pivot-table.html)

pkahm

how do I consolidate multiple pivot tables into one pivot table?

I have 6 pivot tables on 6 different tabs in Excel and I want to combine them
so I can have one main pivot table. Does anyone know how to do that?

All times are GMT +1. The time now is 03:27 PM.