Hey gents - I'm looking to automate a line of code to copy worksheets from a list of sheet values.

Here is the code I got from the macro recorder:

Sheets(Array("MA", "MD", "MI", "NY NJ", "PA", "TN", "TX")).Copy

Instead of adding all of the sheet names into the above code one by one, I'd like to refer to a list of sheet names found on a sheet called Lists!G2:G10 (this list could grow or shrink).

How can I do this?