The SHEET function includes hidden sheets in the numbering sequence.

Whenvalueis omitted, SHEET will return a numeric index for the current sheet (i.e.

the sheet the formula exists in).

Excel formula: List sheet index numbers

When no arguments are supplied SHEETS returns the total number of sheets in the workbook.

Excel SHEETS function