Yes. Keep in mind that "name" of the worksheet may have two different values. Are you wanting to do this manually? In the Project Explorer window, you will see something like:
Where the name inside the parentheses is the name of the tab (changed in Excel), but the the first name prior to the parentheses is underlying name Sheet1. You can change that name by looking in the Properties window (hit F4 while in VBE, and it will appear below the Project Explorer). The first itme is the name. In the second column you can double click and change the name "mySheet". Then the reference in the Project Explorer will look like this:
If you can the tab name in Excel to something else, then it will look like this:
Is this what you were wanting?