Autoupdate Pivot Table for New Range

[Skeezix]

I have a 50-sheet workbook. The first sheet contains a
long list (>40,000 rows) and the next 49 sheets each
contain a pivot table that collects data from the first
sheet.

Each month the number of rows in the list changes as rows
are added and deleted. Each month I have to update the
pivot tables. How can I do this without having to use the
wizard and manually drag through the new list?

 

[Debra Dalgleish]

If you use a dynamic formula to name a range, then use that as the
source for the pivot table, the new data will be included when the pivot
table is refreshed.

There are some instructions here:
http://www.contextures.com/xlPivot01.html#Dynamic