Need a macro to make workbooks based on employee names

Hi Friends I am attaching an Excel with attendance record of employees...I would like to have a macro to create workbooks based on employee names..ie for each employee there should be a workbook which contains his/her attendance data...Also please advice if I can have an outlook macro to mail these workbooks to employees without me having to manually do the same...