Updating Data Source of Pivot Table

[tatartayfur]

[TABLE="width: 99%"]
<tbody>[TR]
[TD][TABLE="width: 100%"]
<tbody>[TR]
[TD]Hello everyone;

I have question about pivots. I have one excel file which consist 4 sheets. In 4 sheets have more than 10 pivot tables. Every 15 days , my source data is changing(adding new datas) but I have to update new data source one by one manually for 40 pivot tables. Is there any easy way to update data source and pivot tables automaticly instead of manually

Thanks for advance


[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
​