Combine 6 Worksheets to 1 Worksheet with total amounts

[Ms. D]

I have 6 worksheets from Jan, Feb, Ma,r Apr, May, Jun that have different
information on each worksheets. And would like to have another worksheet that
would combine all the different codes (over @120 lines) with the appropriate
dollar amount for each city. For Example

Jan

Code Atlanta Chicago Detroit
300 - Bill Expense 359.23 234.23 1132.32
301 - Process Fee 65.00 45.00 50.00
400 - Bill Expense 4560.00 333.22 232.32

Feb

Code Atlanta Chicago Detroit
300 - Bill Expense 359.23 234.23 1132.32
301 - Process Fee 65.00 45.00 50.00
302 - Sales 3333 4444 5555
400 - Bill Expense 4560.00 333.22 232.32

and so on

Total

Code Atlanta Chicago Detroit
300 - Bill Expense 359.23 234.23 1132.32
301 - Process Fee 65.00 45.00 50.00
302 - Sales 3333 4444 5555
400 - Bill Expense 4560.00 333.22 232.32

 

[Ms. D]

Sorry, wrong info for Total worksheet

Total
and so on-->
Jan Feb
Jan Feb
Code Atlanta Atlanta
Chicago Chicago

 

[Herbert Seidenberg]

Pivot Table with
Consolidate Ranges,
Page as Column
http://www.savefile.com/files/1683348