Need macro to consolidate a list of products one by one into a macro enabled excel sheet

Hi guys,

I really hope you can help me with this one:

I have workfile : example 11 (macro enabled).
In the 'welkom' sheet the data of a student gets extracted out of a masterfile (which in this file is in sheet2), this happens with a large function which I didn't copy here the extraction is based on the name in cell B1.

I have a seperate list of students (a class) in file : example 2.

Would it be possible to help me out with a macro allowing me to : select the first student in the example 2 file, put it in cell B1 of example11 (sheet Welkom), run the macro behind the button (save button, this macro is copied under the button) and jump to the next student in file example 2 doing the same..?

I know this means i will probably overwrite my additional data list in B1, but I will just copy the file..

This has to happen for 500 students..

Looking forwards to your response

Kind regards,
Thomas