How do I create a dropdown list that lists all the calc sheets in the same directory?

[Madmaxneo]

Exactly as it says. I want to create a dropdown that automatically lists all the sheets in the same folder as the sheet the dropdown list is in.
I assume this has to be done (via a macro) in basic or python of which I do not know either.

Additional question: Do the other sheets have to be open to pull data from them? I ask because I plan on pulling data from specific cells in specific sheets within a folder but I hopefully do not need to have them open.

[Wanderer]

@Madmaxneo

assume this has to be done (via a macro) in basic

Depends. For a more or less static folders you can simply write abdir or ls cimmand to a text-file (use .csv as extension). Importing this and using it as source-list for data–validity may give the same function.

For a macro you may sart here:

Get A List Of File Names From A Folder And All Subfolders

It appears to me Libre Office can do this (Excel example link below). My best efforts to recreate this in Libre Office always ends in a hung application (crashed). I suspect this is already explained or has available info but I can’t find the answer or I’m failing to understand the “how to” within Libre Office. I’ve been able to duplicate a similar process to get some info from directories but this example appears to provide much more useful available options that would be really handy. Tha…

[fpy]

@Madmaxneo

I do not know

here’s a reasonable starting point : Get A List Of File Names From A Folder And All Subfolders

@Madmaxneo

other sheets

→ Addresses and References, Absolute and Relative