Is there a way for me to list down all the sheet names of the document in a separate column or sheet?

I have a file that has a lot of sheet names and would need the names listed in a single column of another sheet within the file to serve like its directory

Choose menu View - Navigator (or just press F5), press on the Drag Mode icon (a world with chain links) and select Insert as Hyperlink, expand the Sheets category, then drag the sheet names one by one to the desired cells.

Sheet names to cells animation.

Done on LibreOffice 6.3.6.2 (x86); OS: Windows 6.1.

hallo

The Navigator →F5 still exists, and is available from everywhere in Calcdocuments!