Auto refresh pivot tables when data changes with slight twist

[rs1aj]

I have a workbook that will update information(query is run) to the "Data" worksheet when the file is opened. I've built three pivot tables on worksheet "Pivot" pulling information from the "Data" worksheet. I have a third worksheet called "Dashboard", where I display information from the pivot tables.

I would like to hide all the tabs(worksheets) except the "Dashboard" so no one gets lost selecting the other tabs.

Anyway, on to my problem. Since the "Data" tab is updated every time the file is opened or by selecting the option (Data,Refresh All), I would like for the three pivot tables on the "Pivot" tab to be updated automatically each time the query runs. I tried to refresh the pivot tables using a marco in the "View Code" portion on the "Dashboard" tab but since the "Pivot" worksheet was hidden, I received an error. I would like for the user to never see the marco activating other tabs, refreshing and then switching back to the Dashboard tab. Is there a way to auto refresh the three pivot tables in the background, while the "Pivot" tab remains hidden, each time the data is updated?

[rs1aj]

Just needing to update pivot tables on hidden tab when file is opened or data is refreshed.