Excel SHEETS function
Function SHEETS
Description Excel SHEETS function returns the total number of sheets of the reference. If reference is not provided then SHEETS returns the total number of sheets in the workbook.
Syntax SHEETS([reference])
Reference [optional] A valid reference to a cell or range.