Just wondering if there is a way to reference a sheet without using its name.
I know in VBA you can reference the first, second, third etc. sheet or use
their names.

I want to use a formula that references a certain sheet dependent on a
different cell value. For example: if cell a1 value is 3, then my formula
will refernce a cell on the third sheet. if cell a1 is 2, then the formula
would reference the same cell but on the second sheet.

Thanks in advance for your help.