Hello

Can I somehow wrap the "=GET.WORKBOOK(1)" function used with Name Manager to get the workbook and sheet names of 'other' excel files (not the active workbook) if I have the file path of each file ?

I am trying to create a list of SHEET names from numerous excel files.

Thanks