need help on creating excel form for many employees

[naa17]

Hi All

This is the first time I post a discussion here. I am doing work takes a long time to complete when I know there is a way to do it in just a few minutes. In my work, I have a list contains employees' information in the excel sheet list is about 100 employees. I have to copay and past each employ information to another excel form and save it by the employee name and ID number. I have to do this for each employee means I have to create 100 excel files!!. Is there a way to do it automatically?

thanks