i have grades for students i wanna arrange them in a certain order in order to put them after in certificate for each one
i have 2 worksheets the first one have all the grades and the other sheet will read from the previous sheet in a certain order like the following example
first student

C2 = sheet!C2
C3=sheet!E2
C3=sheet!G2
and so on till
C10=sheet!s2

then the second student will come in C11 and should repeat the first sequence like the following

C11=sheet!C3
C12=sheet!E3
and so on

how can i fill this sequence can u help me