I have a pivot table on one worksheet and in another I'm trying to use the
getpivotdata function to pull out data based on cell references.

Worksheet: CNM (A4:E10)
Headings: Client Ref / Visit Date / Company / Month 1 / Month 2
Detail: 1234 / 01/03/2007 / ABC / [monetary data from pivot table] /
[monetary data from pivot table]

Worksheet: Pivot (A3:J198)
Row Fields: Client Ref / Company / Company
Column Fields: -3 / -2 / -1 / 9 / 10 / 11 / Grand Total
Data Items: the monetary data I am trying to extract.

I've tried to use the advice given by Debra Dalgleish on her website
(www.contextures.com/xlPivot06.html), but, I cannot get it work. (I am using
Excel 2000.)

I've entered:
=GETPIVOTDATA(Pivot!$A$4,"-3 "&C6 & " " &C6 & " " &A6)

where the '-3' relates to one of the columns of data from the pivot table
that I want to extract from. If it helps, my worksheets are organised as
follows:

Basically, I need to extract the value in column '-3' which matches the
company name, the company name (again) and the client ref.

Any ideas?