Quickly insert all sheet names in cells with VBA If you want to inset all sheet names in cells, VBA macro is a good choice Step 1 Hold down the Alt F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window Step 2 Click Insert > Module, and paste the following macro in the Module Window VBA for inserting all worksheets' names in cells How do I reference an excel sheet name in an excel formula?How to Find #NAME Errors If you're working with a large dataset, it may not be obvious where all of your errors lie There are a few ways to find #NAME errors in Excel
Excel Formula Dynamic Worksheet Reference Exceljet