Hi Debra,

Thank you for your reply to my question. CyberTaz also responded to my
question and both of your answers gave me a better understanding of how pivot
table works.

I will definitely go to the link you've provided.

Many thanks!!
May-Yen

"Debra Dalgleish" wrote:

If you create a Pivot Table from multiple consolidation ranges, you
won't get the same pivot table layout that you'd get from a single
range. There's an example he

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

If possible, store your data in a single worksheet, or in a database,
and you'll have more flexibility in creating the pivot table.



May-Yen wrote:
How do I run a pivottable report w/ multiple worksheets as my data sources.
All worksheets are from same excel file.

I would be pleased if someone can advise.

Thank you.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html