I need to write a macro that will create a tab based on the change of data in a specific column.
My data spreadsheets all contain information about reps. For instance I run a monthly commissions report from our database into excel. It will list details on every job billed within the time frame i chose. Each record (row) contains both job info and the rep name attributed to that job. Once the data is sorted i need to create a tab based on the change in the rep column.

$549.00 $549.00 $0.00 Jeff Beck Client
$549.00 $549.00 $0.00 John Bonham Client
$947.38 $1,698.50 $0.00 Jimmy Page Client
$947.38 -$766.62 $0.00 John Paul Jones Client
$856.90 $856.90 $0.00 Perry Farrell Client

So let's just say the data above contained about 6000 lines each being a specific job and each job being tagged to a specific rep. Once i sort the data (or incorporate that into the macro) i want to have a macro that recognizes the change in rep in the rep column and creates a tab with the name of that column and places the data pertaining to that specific name in the worksheet..