If you look at the worksheet in the Project Explorer in the VB Editor, you will see it has two names. The first one is the code name, and the one in brackets is what appears on the sheet tab. You can simply use the codename as an object in your code (it's like a worksheet variable) - for example:

msgbox sheet1.name