Excel Hack 93: Compile the names of all worksheets in an Excel workbook into a range…in minutes!
Create a new sheet for the compilation. Leave the sheet name as Sheet1 (or if you choose to rename it, note to change the reference in the below VBA code). Go to the Visual Basic Editor and insert a new module (see Hack 85 on how to do this) Place the VBA code below into