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.