Gives the name of the worksheet to the immediate right of the sheet where this name is used The 0*Now () is added to ensure the names are "volatile" and get recalculated on every calculation of Excel To refer to cell B1 on the previous worsheet, use this formula =INDIRECT ("'"&PrevSheet&"'!"&CELL ("address",B1)) Likewise for the next Excel Online Need to have a cell on a sheet equal to the sheet name This formula will exist in a cell on many sheets Changing the sheet name will update the cell This is easy to do in Excel 16 Creating a name in Excel To create a name in Excel, select all the cells you want to include, and then either go to the Formulas tab > Defined names group and click the Define name button, or press Ctrl F3 and click New
Current Sheet Name As The Criterion In Google Sheets Formulas