Need VBA coding assistance

[Meko1]

Hello, since I am quite new to the VBA coding I would appreciate if one of the excel gurus could help me out.

So I want to create a button which on click will run the following:
I want it to copy-paste the data from sheet "student 1" to sheet "contract 20" and afterwards to print it. For example from B5-->to B3, C3 as you can see from the images.
At the same time I need to consider that I have few hundreds of student sheets like "student 1", "student 2"... and all the information is inside in yellow color is entered by hand.
So macro needs to understand the sheet I am standing at and from that sheet copy-paste data to the contract and afterwards to print it.
Another issue with the contract is that as you may see it is written as a text, using Concatenate or just "" and the data I am filling from the student sheets in some cells it comes after the text.

P.S. as you may see contract is in 2 language my mother tongue and English and in student sheets the data is entered similarly but if you can help me out just doing it on English it would be awesome.

I would be very grateful if this can be done.
Thank you in advance.

 

[Craig_Moore]

would you not be better using vlookup instead of the code you want to use
that way all you're students info is on 1 Database and all you have to do is type in the student on the contract so it loads all there details ?