Can formulas look up sheet numbers instead of sheet names?

[country101]

I have a spread sheet that I need to adapt for several differant crews. Each spreadsheet has a sheet for each supervisor. My formulas in my master sheet all draw off of the supervisor sheets. Since the supervisors' names will change on the sheets when I do a differant crew, I cannot re use the formulas without manually changing them. If they were referancing the sheet number instead of name, however it would work, I think. Is this possible?

 

[country101]

Is there any other way you can think of to make things easier to copy over to other crews?

 

[country101]

Nevermind! It appears that when I change the sheet names, the formulas update as well, so I dont have to worry about changing the formulas!

 

[T. Valko]

Nevermind! It appears that when I change the sheet names, the formulas update as well, so I dont have to worry about changing the formulas!

Good deal. Thanks for the feedback!