SHEETS takes one argument,reference, which should be a cell reference, or a3D reference.
When no references are supplied SHEETS returns the total number of sheets in the workbook.
The SHEETS function includes hidden sheets.
SHEET will report the sheet number for a cell reference, named range, or Excel Table.