Grouping Sheets Conditionally
There is an Excel file that teaches how to perform the Grouping Sheets Conditionally operation.
Excel Grouping Sheets Conditionally
This workbook demonstrates grouping sheets conditionally using VBA macros on a 1-row data layout.
Hope it is useful.