I want to use the code name to reference Sheet1, the Sheet is named something
else and the name will continue to change.

Also, the first line keeps failing with ,<type mismatch:

Sheets(Sheet1).Select
--
Thank you so much for your help!