I have 6 worksheets from Jan, Feb, Mar, 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 cityand 0 dollar amount if there's no amount for that
month for that code. 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 490.20 939.30 1239.33
301 - Process Fee 75.00 55.00 60.00
302 - Sales 3333 4444 5555
400 - Bill Expense 2341.50 267.92 403.72

and so on

Summary
Jan Feb Jan
Feb Jan Feb
Code Atlanta Atlanta Chicago Chicago
Detroit Detroit
300 - Bill Expense 359.23 490.20 234.23 939.30
1132.32 1239.33
301 - Process Fee 65.00 75.00 45.00 55.00
50.00 60.00
302 - Sales 0 3333 0
4444 0 5555
400 - Bill Expense 4560.00 2341.50 333.22 267.92
232.32 403.72