Update data range for many pivot tables, referencing same rawData range?

[astrbac]

Hi,

I have a 'rawData' sheet from which many other sheets with nothing but pivot tables are "drawn". There are about 10-ish or so pivot sheets. When I update the rawData the range expands or contracts by thousands of rows at a time which means I need to adjust data-range for each table manually. Is there a way to do this automatically?

As I mentioned:

• 10 sheets, each with one pivot table
• all of them referencin a single data range
• data range on a separate 'rawData' sheet
• data range is about 15 col x 300.000 rows
• data range changes form time to time to +/- couple of thousand or tens of thousands of rows; columns stay fixed

Many thanks!