Refresh data in another worksheet

Hi All,

I'm very new to this forum and have been facing issues with connection between excels and have the below question. I did lots of googling but unable to get a proper result:

Excel 1:
Worksheet Dump: Connects to DB and pulls the data via data connections from SQL DB
Worksheet Pivot Dump: Pivot is generated with the filtering of the data from the worksheet dump

Excel 2
Contains the graphs which is generated from the worksheet pivot dump.

There's a cmd button created on the excel 2. On clicking the Cmd button on excel 2 the data in excel 1 should be refreshed, which in turn refreshes the pivot in excel 1 and also refreshes the graphs in excel 2.

Please help on the same.