An even more secure way would be to use the sheet's code name in code, as the index will potentially change if a user moves a sheet, or deletes/inserts one.
The sheet's code name is the name in the VBE in the Properties Window of the sheet next to the (Name) field (so you can also change it in this window too). Somewhat confusingly, it is also the name that
doesn't appear in brackets in the top left Project Window of the VBE for the sheet. If you use that in code, then you won't have to worry about users changing order or sheet names from the user interface (ie Excel itself) as the code name does not change:
Rich (BB code):
'refer to sheets via CodeName:
Sheet2.Range("A2:A10").Formula = "=RAND()"
'text in red above is the code name (as determined from the properties window of the worksheet in question)