How to Use Tab Names as Variables in Excel. When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window.

Irene Galente asked if she can combine the name data in a number of Excel columns into a single cell. In Irene’s spreadsheet the first column displays each person’s “title” … ...

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