how do i link to a pivot table to get data dynamically

[Michael001]

I need to link a sheet to a pivot table in the same workbook to get the data
value from the pivot table. This also has to be updated dynamically as the
pivot table changes. Can this be done and how.

 

[Debra Dalgleish]

You can use the GETPIVOTDATA function to extract data from the pivot
table. There's information in Excel's Help, and here:

http://www.contextures.com/xlPivot06.html

 

[Michael001]

Hi Debra
Thank you very much for your response, I will give this a go and hopefully
resolve my problem.
Regards
Michael