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.