You can't really do this without VBA in some form I'm afraid (ie Sub, XLM call or 3rd party add-in)

You can return a given sheet name via formulae (in a saved file) using the CELL function, however, getting a list to update dynamically would warrant code in some form or other I'm afraid.