I have been through a lot of avenues, with no success.
I am not interested in cell values that equal sheet names, I want the filename of the spreadsheet itself.
For some reason, Google makes that very difficult.
Like so many other things, their stuff is great, in a vacuum, but not designed by people with real-world experience and needs.