I have to create a report bases on information from 3 separate pivot tables.
I have been able to use getpivotdata for some of the information but because
the pivot tables are dynamic this doesn't always work.