Can pivot tables in worksheet be shared in another excel workbook and changes dynamically?

[Sf1802]

Hello all, I have a workbook with about 10 worksheets. One of the worksheets contains pivot tables and slicers. I would like to check if it is possible share/extract this worksheet with pivot tables on another excel workbook, and that changes will be updated dynamically. Reason being I would like to share this worksheet with some other users and I do not want them to get access to the other tabs within the original excel workbook. I have thought of hiding the tabs , but Administrators have to constantly update the data in the original excel workbook, hence it is not very convenient for the Administrators to unhide the tabs every time they want to update.
Also, I read up some articles they said that the dynamics 365 is a possible solution but my office does not have this function and our office laptop does not have internet access.
Hence, looking for a workaround. Appreciate any suggestions. Thank you!

 

[SpillerBD]

Use a Query to link the data and have the single Pivot Table in that.

 

[Sf1802]

Thank you! I have managed created another workbook to link the pivot tables to the original data file. Also ensure that the file directory for the data source doesn’t change.