Notes: If you save your range names to the workbook instead of the individual worksheets, you can create formulas that calculate your named ranges from anywhere on any spreadsheet in the workbook.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.