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

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.