Is this possible without delving into macro-land at all??

AFAIR it is impossible. It may help to know that Calc knows the concept of absolute and relative sheet references analog to row and column references.

Having the "normal" sequence of Sheet1, Sheet2,...

=Sheet2.$A$1 in some cell on Sheet1 refers to the

next sheet. When you copy the formula to Sheet2 it reads =Sheet3.$A$1.

The most minimalistic macro solution is a userdefined cell function in Basic:

- Code: Select all Expand viewCollapse view
`Function SHEETLIST()`

SHEETLIST = ThisComponent.Sheets.getElementNames()

End Function

Now array-function

=SHEETLIST() [Ctrl+Shift+Enter] returns a horizontal vector of sheet names.

=TRANSPOSE(SHEETLIST()) [Ctrl+Shift+Enter] returns a vertical vector of sheet names.

A1: =INDEX(SHEETLIST();0;3) returns the name of the third sheet.

A2: =ADDRESS(1;1;1;A1) returns "$Sheet3.$A$1"

A3: =INDIRECT(A2) returns a reference to "$Sheet3.$A$1"