A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

There are powerful features within Microsoft Excel you can use in the form of the Power Query and the VSTACK functions.