Column PasteValues to a DYNAMIC DESTINATION

[PendingExcelWizard]

As I go through the data validation, I wish to paste column C:D into A:B on sheet "1".

Next data I wish to do the same, but this time sheet "2"


Sub Range_Copy_Examples()

Worksheets("1").Columns("A:B").Value = Worksheets("Model").Columns("C:D").Value

End Sub


However, I have to iterate Worksheet "1" and run macro for 1,2,3,4,5,./


Something like?

Worksheets((Model(A1)).Columns("A:B").Value = Worksheets("Model").Columns("C:D").Value

[PendingExcelWizard]

Model Sheet & 5 target sheets. (6 in total)

There are 5 data validations on model sheet, with 5 different sets of data pulled through.

How do I change the above VBA code, to spew the data into the adjusted validation data. ATM "1" is static, I wish to have 1,2,3,4,5 all built into the code.

Thanks again.