Sort and New sheet help
 

Hi All
Need some help.
I have about 8000 lines to sort on a daily basis via excel

What I need

I have A-P Colums across
And 8000 - 10,000 lines going down

Colum C= Sales person's Name
There is about 20 or different names
What I need is so that for Every sales person it creates a new Sheet
Called (Sales person's Name reps name new names added every day)


Then puts all the info from each line that has there name on it.
And it puts all info from Colum

Hope it makes Sense