Help!

I need to be able to extract ALL of the data from a pivot-table's cache.

One of the departments require us to use a "dynamic" pivot-table as our source of information.
But, we don't have the ability to update the pivot data and the will not share the password
to the external database. I know, silly huh? But, rather than manually moving the fields
in the pivot table every day to copy and paste the data we need, I would much rather
create a macro that extracts and imports the data into my report where I can query
or create functions to report on the daily metrics.

Currently, I'm unfiltering the Pivot-Table and double clicking the grand total
and copying the source data into my report. I want to write a VBA script
in my report that opens their report, finds the pivot table, and imports the
pivot-table cache data. Or, if there is some way around the password to the
data source, that would be ideal.

If anyone has a better idea I'm also open to that.

Please Help.

I thank you for your time.

TJ