I have a list of Names (Name1, Name2, Name3, etc) and I want each Name to go through a series of actions:

1) Application.Goto Reference:="Name1"
2) Range("Name1_variable").Copy
3) Take some other action

4) Then, repeat the sequence for Name2


How do I go about doing this?