Pivot Table

[claude jerry]

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

 

[Greg]

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.

 

[Herbert Seidenberg]

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

 

[claude jerry]

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]

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

 

[claude jerry]

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

Appreciate your time and patience, keep it up !