Counting Sheets Automatically
There is an Excel file that teaches how to perform the Counting Sheets Automatically operation.
Excel Counting Sheets Automatically
This workbook demonstrates counting sheets automatically using VBA macros on a 4-row data layout.
Hope it is useful.