Get Pivot Data from External Workbook

Hi,

Assume that I have 2 workbooks, WB1 and WB2. Assume that both workbooks are open at the same time.

WB1 is the output workbook and WB2 is the source of the data with the pivot tables. Note: WB2 has multiple sheets, each of which has multiple Pivot tables PTA, PTB PTC, PTD....... PT 'n'.

I want a formula in WB1, that retrieves data the first line of the rowfield data, in PTA, on Worksheet1 from WB2.


Thanks in advance.


AXl

Not familiar with the concept of UDF's I'm afriad, I will probably need spoon feeding.

I have attached a dummy workbook.

WB1 is the output
Wb2 is the source

The pivots are labelled as follows: AllPivot1 AllPivot2 AllPivot3 etc.

In WB1, for AllPivot1:
I would like the first data under "Sec-Name".

for AllPivot 2:
I would like the "Total" for the first "Ast-Asset Currency Name"

For AllPivot3:
I would like the "Grand Total" for the "lowest Rating".


WB1.xlsWB2.xls

Well, what happens is that there is a macro which filters out the data from a different workbook and THEN creates the pivots. So to start with the pivots are not there.
But once they are created, then yes they are always in the same place, however the data may vary and so the pivots may lenghten or shorten.