For each sheet To get the name of each sheet, you must use the Name method;1 = CELL(filename) To get the current worksheet's name, you can use the function with or without the optional reference argument, referring to any cell on the current tab 1 = CELL(filename,A1) You can also get information about any other worksheet by referring to a cell on that sheet 1Then select Data in a range option from the Sheet names based on list box, and click button to select the cell values that you want to use 3 And then click Ok button, the worksheets have been created with the names of the cell values in a new workbook, see screenshot
List Sheet Tab Names With Excel Vba My Online Training Hub