How to refresh a specific Pivot Table if data in another Pivot in the same worksheet has been changed

[gilsa]

Hi,
I am trying to use VBA to automatically refresh a specific pivot table which is based on another table which the last based on another pivot table.
All data resides in the same worksheet.
Once the first pivot is being changed the table of course get updated but the pivot which is based on doesn't.
How can I do so?

Thanks,
Gil