copy or remove particular count of records and pasting in another excel workbook

Hi

i have a multiple records (30 k) in a excel workbook , in that i want take only 3 records of email per company,

ex: the company having 10 email in that only three email i need to copy or remove and keep in separate excel workbook.

if the company having less then three, the same count or email i need to copy or remove and keep in separate excel workbook.

i have kept the same file also.

please help me how to do.

thanks and regards
Josh