if I have code such as this..
Dim es As Worksheet, etd As Worksheet
Set es = Worksheets("Master Employee List")
Set etd = Worksheets("Jan Week 1")
You can see "es" & "etd" are being declared, and set to Jan Week 1 worksheet.
How can I write this to accept for example where I have quite a few...