Splitting Workbook In Order
There is an Excel file that teaches how to perform the Splitting Workbook In Order operation.
Excel Professional Splitting Workbook in Order
This workbook demonstrates splitting workbook in order using VBA macros on a 15-row data layout.
Hope it is useful.