change source data for multiple pivots

Hi all
Hoping you can help.
I run basic management accounts for a number of cost centres using a single data source, the accounts are pivot tables and also include breakdown of major cost items (materials/salaries etc) which are also pivots on separate tabs. I end up with about 10 workbooks, each with up to 10 tabs for line item analysis, all of which are pivot tables. The data source is approx 30,000 rows and a new file is used each month.

i want to be able to update the monthly accounts as quickly as possible. This will be the second month I've set these accounts up however I'll currently have to go into cost centre A to change the data source, and then into each tab and change the source there. I'm using Excel 2010. How can I link the pivots so if I change the data source once all tabs in the workbook are updated? Ideally i'd like the change the source data once and all workbooks get updated.

Thanks in advance
Gareth

I've copied the data range into new files (they were read only) and named the data range for each file 'Data'. However when I change data source for each tab it only changes the data in that tab - how do I link all pivots so they are all running off the same data and I only need to change the course once?
Apologies if im missing something obvious here, can't seem to get it working how i'd like...