In one of my projects I had to read all worksheet names from several Excel files.
Here is the code for getting all worksheet names from a closed or already opened Excel file.
Referenced Functions can be found below.
Getting all sheet names from a workbook
Getting an opened Excel workbook