If you have simple tasks that you need to perform in Excel often, you can actually “teach” Excel to do them for you by recording a macro.

Then in cell B2 enter the formula =INDEX (SheetNames,A2), and then copy and paste the formula down 25 rows. These formulas will return a list of the names of your worksheet tabs in the same order as ...