Linking Pivot Tables

Hi, I have a file(which is attached at the bottom) which has multiple sheets that have a pivot table on every sheet located at P2. what I would like to do (if it is possible) is to link these together so if I change the Date filter to only view the current month, then all of the pivot tables would change to that.

I would also like to add a summary sheet which would compile the data of all of the pivot tables, and then I can create a chart that would display everything. Is this possible?




Time Lost Form.xlsx

Bump, does anyone know of a way to refresh all of the Pivot Tables at once?