Often times it’s useful to be able to display your worksheet’s name in a cell in the worksheet. This could be tedious if you have a file with a lot of sheets, whose names could change frequently. Luckily there are a couple ways around this problem.
If you want to display this information in a cell in your file, enter the following formula in the cell where you want the name to appear:
Anytime you change your sheet’s name, the formula will automatically update, so you never have to edit the name in the worksheet as well.