You could set the on_change event for the worksheet with the data table
on it to refresh the pivot tables. If you make pivot tables 2-8 linked
to the original pivot table, then you only have to refresh one for them
all to work

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=560160