Automatically generate timecards (new sheets)

I have a raw data file which lists all my employees in a column like so.

EmpName			PayrollDate	WorkOrder		CommissionPay	RatePlan
Castaneda, Carlos	5/6/2013 8:30	20397-1			360.89		Supervisor 12%
Castaneda, Carlos	5/7/2013 8:00	23051-1			232.2		Supervisor 12%
Castaneda, Carlos	5/8/2013 8:00	23996-1			321		Supervisor 12%
Castaneda, Carlos	5/13/2013 8:00	23809-1			310.44		Supervisor 12%
Castaneda, Carlos	5/16/2013 8:30	24071-1			122.4		Supervisor 12%
Castaneda, Carlos	5/17/2013 9:00	20952-1			1000208.2	Supervisor 12%
Gaiton, Christopher 	5/16/2013 8:00	23655-1			88.44		Tech 8%
Gaiton, Christopher 	5/16/2013 12:00	22434-1			13.5		Tech 8%
Gaiton, Christopher 	5/17/2013 9:00	20952-1			1000104.1	Tech 8%
H, Carlos		5/6/2013 8:00	23816-1			37.7		Lead Tech 10%
H, Carlos		5/6/2013 11:15	21083-1			18.5		Lead Tech 10%
H, Carlos		5/6/2013 14:00	23643-1			63.4		Lead Tech 10%

I've created a timecard spreadhseet which tracks commissions and wages using data exported from my system (basically what I pasted above). It does various things like tracking overtime, making sure they're getting paid at least minimum wage and other controls to ensure payroll is being setup correctly. I've attached a copy of what I've created along with the raw data which is contained in one of the sheets.

I want to find a way for my workbook to scan this raw data and create a sheet/timecard for each worker automatically within my workbook. Each sheet would use a template and there would be just one cell that would need to be populated with the employees name.

Is this possible with Excel?