SHEET function - Support

This article describes the formula syntax and usage of the SHEET function in ... Value is the name of a sheet or a reference for which you want the sheet number. ... data in the following table, and paste it in cell A1 of a new Excel worksheet.

support.office.com