Duplicate and link workbooks in excel

[JSH720]

I need to create a “workcopy” of a workbook with many worsheets. Once created, I need to update the workcopy manually to upload changes and redo powerqueries etc from the workcopy is this possible and if so how to do it with or without macros?



Thank you