Pivot table help over multiple sheets

Hi guys,

I am a bit stuck and need some expert help!

I have a spreadsheet attached (I've taken out the personal details columns), so just 2 columns that the pivot looks at - Country and Paid.

I have all the months in different sheets including emerging and 'Switzerland' for each month which need to be kept seperate.

I have started to create a test pivot on the 1st months sheet, I would like to know whether i have to do this on each sheet or can I do 1 pivot that adds up 'country' and 'paid' columns for each month and displays this info?

thanks

Hi Thanks for reply, however thats abit confusing! I was thinking about created a pivot for each sheet then a sheet to add all the pivots on each sheet, anyone have any ideas or quicker ways to do this?

Thanks

I have attached a new test workbook as 1 of the country columns was incorrect, Please could anyone give some help - I need something to add up all paid status's for each country and each month and display this, I was thinking of doing a pivot table for each sheet then somehow adding up this figures on a new totals sheet, is there an easier way?

Thank you

Hi thanks for reply, its because each month has to be kept separate, so is there anyway to do this please?

Because each month has to be laid out on separate sheets as they originally came from separate workbooks, thanks for your solution however thats not really what im looking for as i would like eg. greece to show total amount 'paid' 'unpaid' 'cancelled' etc in a neat sheet.

Hi thanks for your replies Im very grateful for the help! The problem i have is the months data will be updated by other people aswell so i need to be able to refresh the data, I am using excel 2007 at the moment and I can't edit the sheet you kindly created (oeldere)?