Pivot table question
 

I have multiple pivots to update multiple charts automatically.

All pivots are the same, each choose a different value for one of the
pivot fields. One of the common fields is for the week of the year.

Every week when updating the tables I drop one week off and add the
new week at the end of the selection for the pivot field for the week.

Is there a way to tie all these cahnges in the weeks together so that
I do not do it for each pivot table seperately?


Thanks!

Deguza