Pivot tables out of several pivot tables

[wcthrill]

is this possible? or do i need to use the getpivotdata function only?

 

[BrianB]

I think the best way is to put all the data in a single table. Can still extract to numerous pivot tables.

=VLOOKUP() is a lot easier than GetPivotData. Can make unique values by making a new column with formula like =B1 & C1 and use that for lookup. Hide the columns if necessary.