consolidate pivot tables and have 1 that reports all

[noel1]

Team

I will create the scenario for this.

4 excel sheet tabs names 1 to 4.
5 column headers named 1 to 5
4 rows per sheet named
column 1 = A Col 2=B Col 3=C Col 4=1 Col 5=D

Repeat this for the 4 excel sheet.

So I want a consolidated pivot table that I can select Col 1, 2, 3, 4 and 5.

So each new table I create I add to data model so it shows as the range.

Then I create sheet 5 and then add in the pivot tables.

So I need to get to the point that i can see the sub total for each sheet and then the grand total in the end fields.

I get so far but not to the point where I can see the correct total of 16 for col 4.