Collection For Worhsheet, Worksheet, and Worksheet Collection
Excel Sheet And Workbook. Copying sheet(s) to a new workbook. Don't worry about file formats again.
When you open a new blank workbook, excel puts a single worksheet in it by default. Rename the file extension to.zip. So to get the missing sheet tab back you must use the unhide worksheet of excel
Assure that the show sheet tab checkbox is selected.
This probably sounds quite confusing, but we will make it clear. Dropdown to your preferred number of sheets. False when the event occurs. Now all names exist in table2 from another workbook/worksheet are copied into current workbook/worksheet.