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 ...

Saving Excel ADI worksheet for use; name file and change ‘save as type’ to ‘Excel Macro‐Enabled Workbook (*.xlsm)’ from drop down. Perform physical inventory: Inventoried field (far right of template) ...