Copy names from one worksheet to another and copy

Hello,
I have an issue at work that a macro, if it is possible, would be extremely useful.

I have an excel file with a list of hundreds of first and last names and another one with a template that I should write each of these names and print it.

I understand it is very difficult but does anyone know if there is an automatic way to do that?

Thank you in advance.