Looping Macro to split one worksheet into multiple

Hi Everyone

I have a master spreadsheet eg:

A B C
Name Product ID Result
Steve 57 good
Dave 57 good
Steve 60 ok
Steve 56 ok
Steve 34 good
Dave 56 bad
Dave 23 bad

What I want is a looping macro to create a new workbook (i.e. not a sheet within the existing workbook) which is named Dave.xls and Steve.xls

I want the headers included and the formatting to remain the same if possible.

I would also like to define the location to save them.

Is this possible? I was asked not to use a filter as last time this didn't work properly (the spreadsheet is very large).

I was also asked to provide failsafe check, I understood it as being some kind of check which ensured that Dave.xls only had Dave's information in it and that all of Dave's information was in Dave.xls. If this isn't possible, or makes no sense, that's ok.

Many thanks for your help!!