Automatically generate timecards (new sheets)

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

Please Login or Register  to view this content.

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?