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