Creating a Master / Consolidated Pivot Tables from a multiple pivot tables

Hi All,

I have a four pivot tables and I want to merge all the four pivot tables into one Pivot tables.How can I do this ?As enclosed in attachment,I have a sheet named 'p' where I have formed four pivot tables with the data next to it.However the respective heading of Pivot tables are mentioned in A2,D2,G2 and J2 respectively.I want to merge all these into one.

With Best Rgds

Hi,
You will find attached your file with a "consolidate" sheet.
You have to load wizard pivot table and consolidate each sheet with a field page name.
Note : I didn't arrive to consolidate the field "Vch No" but I am sure somebody will take care
Hope this help
Best regards

Hi,
Thanks for the reply.But I could not be able to get it.Currently I am using excel 2013.Can you kindly tell me the how to load wizard pivot table and consolidate in this version.
I will also eagerly waiting that someone might consolidate the field "Vch No" and other filed simultaneously.

With Best Rgds

Hi,
You will find attached your file with "PT" sheet.
You can see that now all the fields are available.
It is too complicate to explain in detail, done with Query.
But you can see "Contexture Blog" from Debra Dalgleish Create a Pivot Table from Multiple Sheets
Best regards

hi,
still not satisfied.