To rename the selected report sheet:
Select the Format > Rename Sheet item in the Cells group of the Home ribbon tab.
Select the Rename context menu item of the selected sheet tab.
Executing one of these operations opens the Rename Sheet dialog box:
Enter new sheet name in the appropriate box.
When a sheet is renamed, the formulas referring to this sheet are automatically adjusted. For example, the formula =B0+1+"Sheet2"!A0 after the Sheet2 is renamed to Data, looks as follows: =B0+1+"Data"!A0.
See also: