Update separate table when info in Pivot Table is updated

[constantinet]

I have a spreadsheet with employee information data, on a weekly basis I have to add data to the spreadsheet. I have a separate tab in same workbook that I create a pivot table based on employee information data. I update the pivot table on weekly basis with a simple refresh.

The pivot table shows employee name, earnings, and then deduction number if I click on deductions number for employee a separate worksheet with table opens with the employee name, wage info, and deduction number.

My question is there away for the separate worksheet with table to update automatically when pivot table is updated? My reason is I want to show the pivot table for quick review and then I would like to be able to see the separate tabs for more detail information. I do not want to have to update each week as I want each tab to have the employees name and if I create a separate table each week it creates a bit of work.

Thank you for advanced for any help.

 

[SpillerBD]

No.
The separate Table is akin to an Advanced Filter Result copied to a New Sheet.

Alternative. Create another Pivot Table that shows all the Detail and use slicers.
Alternative 2: Use the Show Filter Pages and use Copy Paste Values to disconnect the displayed data from all the underlying data.