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.

Dear Jency

Try Pivot Table|Multiple consolidation of ranges. Incase of any help let us
know.

Refer http://www.contextures.com/xlPivot08.html for help.

If this post helps click Yes
---------------
Jacob Skaria


"Jency" wrote:

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.

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.