getpivotdata in excel 2007

[Fern]

=+GETPIVOTDATA(pivot1,$A$3 & " " &B$2 & " " &A5)

I'm trying to return pivot table data to another sheet. The range of the
pivot table is called "pivot1" and the reference cells represent (name of
doc), (date), (procedure type). I get a REF#
I have spent hours already and need a solution fast.

Please

 

[Debra Dalgleish]

What formula do you get if you type an equal sign, then click on a data
cell in the pivot table?
Adapt that by replacing the item names with cell references. For example:

=GETPIVOTDATA("Qty",pivot1,"Doc",$A$3,"Date",$B$2,"ProcedureType",$A5)