Splitting data from sheets into seperate workbooks based on formula?

Hi all,

I have a problem splitting up data into seperate workbooks.

I have a workbook with 3 sheets.
One is data of one type, second is data of another type. The field names are totally identical in each.
The third simply counts the amount of data in one column of each of the sheets, the user then inputs how many people will use the data giving us amount of data per user.
However i now wish to split the data into the amount of new workbooks as there are users and split the data accordingly across these new workbooks.

I have searched the net and no-one seems to have had this problem, maybe im going at this the totally wrong way,
Any help is much appreciated.

Thanks in advance

Mikey