Hi,

I have around 5 pivot tables in a sheet. The source data for all these pivots comes from a Master data sheet. This master data is dynamic and will be changing on a daily basis. I want the pivot tables to dynamically change the data source, when new rows are added to the master data sheet. Please help me.

Thanks & Regards,

Murali