Divide list into different sheet based on Person name and quantity

Thanks for your support.

Please find attached a small list of just 50 items.

Imagine that I have to split this list (that can be 1000 lines) into 4 people (sheets on a new excel file).

I would like to assign to Luca the first 10 items, then to Elena next 12 items, then to Hanna next 5, then to Alessandra next 5 and finally to Marco next 3.

Last 15 items in the list won't be considered.