Macro

please i enjoyed your videos. my name is Henry an active military guy. i have many forms that i am printing with peoples information i am able to sent the forms to print with those information but the problem is that i have to filter the name one after the other to print each form. i search for names from a list of names i have in excel run it one at a time. i am trying to see if you can help me with a macro that can go through the list one at a time and past the name for me in my pivot table run it and sent it to print.
right now i can only past manually and use the macro and print it but i can not get the macro to get the data from another list and past on my pivot filter to run and print
For instance,
SN NAMES
1 HENRY JOE
2 PET DELT
3 ANDROW MORE
4 TIM VIC

I will like copy henry joe and past it in the pivot filter (which will fill the names on a form that I made and sent it to print to print) make a macro for this but I can not make it to automatically go to the next name ie pet delt and to the end of the list which is tim vic