Try Debra's page on:

Excel -- Pivot Tables -- Multiple Consolidation Ranges

at: http://www.contextures.com/xlPivot08.html

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Derrick" wrote in message
...
I have data in 3 separate spreadsheets (in the exact
format). I want to have a pivot table that consolidate
data from these sheets.

Is this possible?