Change Data Source for Multiple Pivot Tables

[GSCaupling]

Excel 2007

I have a worksheet from which I derive five different pivot tables. The worksheet has data added a row at a time at irregular intervals, but each time data is added I have to change the data source five times for the pivot tables.

Is there a way to set this up so that I can change the data source just once?

thanks,
GS

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]

 

[Gavona]

faq68-1331

Regards,

Gavin