Hi,
As an alternative to multiple consolidation ranges, you can also use Data
Consolidate to get all the data in one worksheet and then create a pivot
table. Data Consolidate is well explained in the Help menu
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Jency" wrote in message
...
Hello,
I need to prepare a report using Pivot, where the source of information is
not in one worksheet. Could you help me here and tell me how I could use
data
from various sheets in one Pivot.