Automating Pivot tables

Hi all, I have a sheet called analysis, I have 3 pivot tables (Pivottable1, Pivottable2, Pivottable3).

If I change the value in cell I2 I would like the pivot tables to refresh.

Please advise how this can be done?

Right click on the pivot table and click refresh or you can hit Atl and F5

I want the pivot tables to refresh based on a cell (I2) value changing - not by manually refreshing each table.

Sorry if that was not clear