I take it the sheet grade has a row per student?

Do you use a unique code/number per student? In the first column?
The headers are in the first row of grade?

Then the cells in your report should contain a formula like:

=VLOOKUP($A$1,grade!$a$2:$z$999,2)

where in A1 (of your report sheet) you enter the code/number, grade!
a1:z999 is the range where you keep the grade/student data and 2 is the
second column from the left where you take the value to be put in the
cell with your formula. Of course you change that last number that for
each data cell in report.
It is presumed the code/number is in increasing order. If not, you should
change the formula to:

=VLOOKUP($A$1,grade!$a$2:$z$999,2,false)

Of course you have to change the cell addresses and sheet name to those
in the design you have made.

The dollar signs in the formula are used to fix the cell and range
addresses so that you may copy the formula to other cells and only change
the number of the column where you pick the data.