EXCEL – PIVOT TABLE

I have a Pivot Tbale that looks an external data in Access. Every month is created a new external data. I have 8 pivot tables looking at the same file. The hard part is evvery month I have to go in each pivot table and change the external data. Is there any way to make um single change? – I could have a master pivot table and than page than but – the problem is my pivot tables are customized in the screen with other information. I cannot just page my pivot tables.

any help?