Good morning everybody,

I have looked through a few groups and I haven't been able to find
what I need to do, so here goes:

is there a standard function/formula that allows you to reference the
work sheet number rather than the worksheet name when referencing a
cell in a different worksheet than you are currently in?

i.e.:

instead of this: "='My worksheet name'!A1"
do this: "=sheet(1)!A1"

If there is no standard, then I will just make the VBA, but no use
doing that if it is not necessary

Tim