I have about 80 workbooks that are supposed to have the same worksheet names
in them, but I know that they don't. I want to gather a list of all of the
worksheets in each workbook in one document. The workbooks are not all
stored in the same folder. I do have the URL for each workbook easily
available to me in an excel worksheet.

Any suggestions?

Thanks in advance,
Barb Reinhardt