You may be able to do this using a User Defined Function--but I wouldn't.
I would imagine that you'd be passing strings to that function--and that means
that those formulas wouldn't update correctly if the codename were changed or
the worksheet was deleted.
And I would guess that if you were trying to retrieve a value from a cell on
that sheet, you'd have to pass it a string for the address, too.
And if you insert/delete rows or columns, then the formula wouldn't update to
point at the new location.
It would be kind of like replacing all your nicely behaved "normal" formulas
with a bunch of =indirect() formulas.
Is there a real reason you need to do this?