Hello,

I have a workbook with some worksheets.
One worksheet contains data tables multiple dynamic names.

I am trying to save this worksheet in a different workbook so it can be updated my multiple users
and copy the sheet by VBA to my workbook.

My problem is: When I delete the worksheet from my workbook and import new sheet with tables & names I get a lot of reference errors.
How should I replace sheet with dynamic names with new sheets (with the same names by different data) ?

Thank you for your help