Splitting and Arranging Sheets
There is an Excel file that teaches how to perform the Splitting and Arranging Sheets operation.
Excel Powered Splitting and Arranging Sheets
This workbook splits and rearranges worksheets using VBA across a three-sheet base structure.
Hope it is useful.