Distributing Data Across Sheets
There is an Excel file that teaches how to perform the Distributing Data Across Sheets operation.
Excel Format: Distributing Data Across Sheets
This workbook distributes records across three sheets based on a Code column, with 22, 9, and 45 rows respectively using VBA automation.
Hope it is useful.