When want to dividing data set into different Excel sheets, then you can use Excel add ins o divide them based on some criteria or predefined sheets number and data can be arranged randomly or based on default order
link to purchase Extra tools add ins for Excel :
https://deyako.co.uk/product/extra-tools-add-ins-for-excel/