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

Ok, more decent approach, based on findings on google of a guy named Jerry

Trying to start out with copying cell 1 of example 2 (datasheet) towards example 11 (mastersheet)

'original version from Jerry Beaucaire'

Sub CopyToMaster2()
'macro goes IN the master workbook,original version from Jerry Beaucaire'

Dim wsMaster As Worksheet, wbDATA As Workbook
Dim NextRow As Long, LastRow As Long

Set wsMaster = ThisWorkbook.Sheets("Welkom")
Set wbDATA = Workbooks.Open("C:\example2.xlsx)

With wbDATA.Sheets("sheet1")
If LastRow > 0 Then
.Range("A1").Copy
wsMaster.Range("B1" ).PasteSpecial xlPasteValues
wsMaster.Range("B1" ).PasteSpecial xlPasteFormats
End If
End With

wbDATA.Close False
End Sub

Not working yet though, Now i need to implement a way to switch to the next value in example 2 (datasheet), and repeat the copy. Leaving out the save for now