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.