Need a macro to make workbooks based on employee names

Hi Jaslake when I run the macro the folder specified will be populated with worksheets named as per employee names..ie each name in the worksheet attached in my first post will have a corresponding excel sheet with only his/her data..

In that folder I can save the attached excel..the macro should create mail according to the email ID and attach the corresponding excel and send it...