Pivot Tables

[goldcomac]

I have a basic understanding of Pivot Tables and have played around
with a few to further my understanding. One thing I'm not clear on is
how to use one in a workbook that has multiple tabs. My workbook
contains 25 tabs today and I'll likely add more in the future. Can I
incorporate all of those tabs into the Pivot Table? The information
I'm trying to pull is Name, Address, State, and Zone.

I'm using Excel 2008 on a Mac.

Thanks.

 

[Daniel.C]

Shane Devenshire wrote a solution here :
http://groups.google.fr/group/micro...e=UTF-8&q=excel+pivot+table+shane+devenshire+"microsoft.public.excel"+sheets+sql#aedc05161906ef9b
Daniel