The SHEET function is one of the information functions. It is used to return the sheet number of the reference sheet.
Syntax
SHEET([value])
The SHEET function has the following argument:
Argument
Description
value
The name of a sheet or a reference for which you want the sheet number. It is an optional argument. If value is omitted, the current sheet number is returned.