Answer:
Right-click on the tab at the bottom of the worksheet and name it to whatever you like. After you have named the worksheets, click the tab and drag to a location on the tab row to whatever position you like. There is no method (except for writing a custom visual basic for applications program) to automatically rearrange the worksheet names on the tab row.