hi Guys,

i have 2 worksheets (ValSheet and SourceSheet) in 1 workbook.

One of them (ValSheet) has dynamic tables with validation list like:

SourceSheet!A1:A3

Now i am opening 2 workbook, deleting SourceSheet from 1 workbook and copying SourceSheet (the same name) from 2 Workbook to 1 Workbook.

Now i have ref error in my validation list in Valsheet like this:

dartavalidation.PNG

why is that?
How can i move all this references together?

Only using ranges or dynamicTables?

Thank you for helping me,
Best,
Jacek