Select the "Multiple consolidation ranges" radio button in the first screen
of the pivot table wizard.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"TD" wrote:

Hi,

Is there any way to run pivot table with multiple worksheet (having same
column and format)?
--
Thanks,

TD