Hi. If I copy a sheet to a new workbook, how can I rename that sheet with a
left function?

For example, the sheet I copied from book1 was called
"sheet1of_the_workbook". In excel terms, I want to rename the sheet
Left(that sheet name,5).

Thanks!