professor-excel.com
Rename Excel Worksheets: Methods, Rules and Recommendations
Rename Excel worksheets in 3 ways. Characters you can't and shouldn't use in sheet names (because of single quotation marks) and lots of tips & tricks.