Macro to copy a selection, paste it in a new workbook then loop

EXAMPLE.xls

Hello

I have a list of data that I have to send out each quarter to a load of suppliers. The list is about 9 columns long and all the suppliers are in supplier number order. (there can be between 3,000 and 30,000 rows of data)

Usually after sorting the list by supplier (there are max 150 suppliers) I have to manually copy down the data for the first supplier, open a new workbook, paste the data, go back to the 1st (master) sheet, delete the data I just copied and repeat. (each time copying the header row across with the data) When I have a workbook for each supplier I then copy the supplier name from one of the columns and save each one down before sending them out.

Is there any way I can write (or someone can write for me) a macro that copies the data, pastes it into a new workbook then looks for the next supplier and does the same and so on ?

If there is a better way of doing this then please let me know

Any help or suggestions would be much appreciated

Please let me know if you need more info or if any of this does not make sense

Thanks very much !!