How to transfer data from one sheet to another without cut & paste method?

Hi
I have two sheets in attached workbook "Problem sheet". Sheet 1 is "Sem4" and sheet is "results". Sem4 contains roll number & name of students with their internal and external marks scored in particular subject of study (currently int & ext columns are left blank). The sheet "results" contain marks obtained by those students in their respective subjects.
I want to transfer the marks of each student from sheet "result" to sheet "sem 4" in their respective columns & rows without using copy/paste method. Instead I would like to know whether there is any other way of transfer the data from "result" sheet to "sem 4" sheet either using VB codes/userforms or using some formulas. Doing a transpose method, then copy pasting them is very long & tedious way.

Can some one help me with suggestion/solution in this regard?

Thanks
Jijesh