The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

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.