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.
.
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!