Is there a means to reference other sheets without knowing their name within a formula.
I know it can be done in VBA with sheets(1) etc and looking for something much the same within a formula (without a UDF).
Sheet order isn't a problem, just their names.
TIA
Bookmarks