How do I pull pivot table data from one sheet to another?

I have a pivot table I like to pull all its data as plain values. Same as when I go to another sheet and in the formula bar type in

='NameofSheet'!A6

And I get the value on the cell.

How do I do that for the entire pivot table or even parts of it?

Thanks

When you point to a pivot table cell, it usually gives you a pivot table formula which you can dissect each element to point to specific values or cells.

If you just want to point to the cell, just use the regular =‘SheetXX’!Cell formula.

Originally Posted by lazyme

When you point to a pivot table cell, it usually gives you a pivot table formula which you can dissect each element to point to specific values or cells.

If you just want to point to the cell, just use the regular =‘SheetXX’!Cell formula.

I can't get the formula right. It return a #value.