Split data from 1 workbook into multiple workbooks based on criter
 

Hope the title isn't too confusing/misleading,
Im trying to split the data in one workbook into multiple workbooks which
will then be saved individually (with same name each time to same location).
I also have a cell containing the amount of data eg 1000, another
containing the amount of people who are in to work the data eg 10 and another
that will have amount of data per rep (in this case 100)
So is there any way for excel to split the data into chunks of 100 in 10
different spreadsheets?
Thanks!!