I need to create a macro that will auto filter rows by column A and for each filter save as a new workbook that is titled by whatever is filtered in Column A.

A, B, C
Rob, 2, 4
Nick, 1, 3
John, 10, 20
Rob, 50, 100

So first filter would create:
A, B, C
Rob, 2, 4
Rob, 50, 100
and save as a new workbook titled "Rob", and it would exclude all other data (nick/john data) in the Rob workbook

any ideas?