Set up variables from values in a range

[Luke1690]

Set wsCopy = Workbooks(Sheets("SHEET2").Range("A10").Value).Worksheets("sheet2")
Set wsDest = Workbooks(Sheets("SHEET2").Range("A19").Value).Worksheets("Rework")

These are not correct but the closest i got. im going to be copying from one workbook to another, i don't want just a static location i want it to pick from a range that will change depending on selection.

can anyone suggest the code i need to use?

 

[RoryA]

I meant that if Sheet2 is in the workbook with the code in it, you should use ThisWorkbook.Sheets("sheet2").Range("A13").Value