Return a Worksheet Name to a Cell

Sometimes, you might want to use a worksheet name in a cell as a variable and also use that worksheet name in a formula. This would enable you to switch worksheet names and have one single formula able to return results from all worksheets.

This tutorial shows how you can display the entire path of your worksheet in a cell using the CELL function. Then, a combination of the MID and FIND functions extracts only the worksheet name from the full pathname, allowing you to use it in formulas.