Selecting Sheets

Redim Preserve arNames(1 to 5) 
Sheets(arNames).Select 
Worksheets(2) 

Worksheet Name - This is different to the worksheet code module name
SS - emm.com/excel-vba-worksheet

You can use the worksheet code module name in your code which can be useful if you think the user might rename the worksheet.