Dear All

Little problem with my pivot table I am trying to build.
I need to consolidate multiples sheets (all identical layout & headers) but
when I do using the multiple consolidatioin range it all breaks down.

The data is layed out like this:

Nominal Code P&L Department Month Budget Total

I need to end up with a pivot table with

Department as a page
Nominal codes in the rows
Month as a column header
Budget total in "Data"

So it look like this

Department (All)

Sum of Budget Total Month
P&L Nominal Codes Jan Feb Grand Total
Sales 4015 / Radio 22000 23000 45000
4016 / Web 2500 2500 5000
Grand Total 24500 25500 50000

Each worksheet will contain the data for different nominal codes (no overlap).

Looking forward to your answers