Looking to use a Range from sheet "Employee List" ("A2:A33") and name only sheets with the beginning codename "FTE*".
<tbody>
Codename
Cell
Range
Result
FTE01 (FTE01)
A2
Todd
FTE01 (Todd)
FTE02 (FTE02)
A3
Steve
FTE02 (Steve)
Table (Table)
Not Renamed
FTE03 (FTE03)
A4
Mark
FTE03...