Collecting the names from other sheet for print
 

I have a sheet format which I print, it fine. no problem.
In the same file another sheet which has 10 names in a same column.
Now I want to print 10 copy with each name seprate on one command.

I mean while printing the first page with first name, the second page with
second name and so on.

Please advise me. what method to do, in details, as I am new in coding.

Regards.

Irshad.