Pivot Table - Capture Changing Totals

[kcleere]

I have a pivot table with 3 possible page selections. Each page selection yields different totals. (one total per)

Is there a way to capture the total for selection 1, store it in a cell in a separate worksheet in the same file and then 2 and then 3 etc in separate cells.

As it is now I make the page selection and then manually cut and paste the total in the correct cell in the other worksheet.

Any ideas?

Thank you