Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

For example, you can use Visual Basic scripts, record and use macros, use Relative References, install add-ins, and more. However, this tab is not available by default due to security concerns.