Getting specific data into specific cells?
 

I have a list of 600 names that need to be entered onto a form.

Each form is located on it own excel sheet.

Each form needs a different name on it.

Can I automate the process of transfering the names on to each form?

If so, how do I go about do this?

Thank you for your help.