I have a worksheet with 12 tabs named as
Jan07,Feb07,Mar07 . . . . . Dec07

Each tab has identical formats in it

e.g data in Tab Mar07

Col A - Month End Date (e.g 31Mar07)
Col B - Names of Person
Col C - Water Units
Col D - Electric Units
Col E - Tel Units
Col F - Water Bill Amt
Col G - Electric Bill Amt
Col H - Tel Bill Amt
Col I - Total Bills Amt

I have a fair knowledge on Pivot Tables
and would like to construct a pivot which gets information from 12different
tabs

My Question : How to create a Pivot Table where Data is stored in 12tabs as
I need to make Analysis Report on one worksheet which shows me Details of
each person's Utility usage, Month Wise for the full year

Since you already have a defining monthly column (Col A), get rid of the
other 11 tabs and use just the one. Once you have everything in one tab, a
pivot table can be defined anyway you like. At worst, you can copy/paste the
original tab with all the details and delete rows you do not need and create
a new pivot table. To me the key concept is to use just the one tabbed
worksheet to accumulate all your information.

Using Pivot Table, Multiple Consolidation Ranges,
12 tabs and VBA.
http://www.freefilehosting.net/download/3fehj

Thanks this is exactly what I am looking for

But how do I understand step by step how this pivot is done !
I din not understand this part

"Herbert Seidenberg" wrote:

Using Pivot Table, Multiple Consolidation Ranges,
12 tabs and VBA.
http://www.freefilehosting.net/download/3fehj

Added a Help sheet.
Corrected problem with macro.
Two Pivot Table names on same sheet
switched when file saved. Gurus?
http://www.freefilehosting.net/download/3fg80

Thanks buddy, Things are much more clear now. ..

Appreciate your time and patience, keep it up !

"Herbert Seidenberg" wrote:

Added a Help sheet.
Corrected problem with macro.
Two Pivot Table names on same sheet
switched when file saved. Gurus?
http://www.freefilehosting.net/download/3fg80