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.