Move rows from multiple sheets to new sheets

Hello,

I have little experience with Macros and need some help. I have multiple worksheets each labeled with different weeks (i.e. "AUG 29 - SEP 3, SEP 5 - SEP 10, etc.) and I have salespersons names in column A in EACH of those sheets. I want to move each row, based on the salesperson's name, into their own worksheet labeled with their name. Unfortunately, the manager that initially created this report did not keep the layout of each sheet consistent. So, I need a VBA Macro that will parse EACH sheet in the defined range of sheets, and copy the rows based on a salesperson's name, create a new worksheet based on that name, and copy all of the rows into the new salesperson sheets.

THANK YOU!