How can I get the name of a worksheet from an Excel file and rename it to a known name?

How can I get the name of a worksheet from an Excel file and rename it to a known name?

If you don't know the name of a worksheet in an Excel file and need to rename it to a known name, then watch this video.