You can do this very simply using the VLOOKUP function. Unfortunately as
your data layout is not clear I cannot give you the exact formula. If you
can improve the column alignment of your example I can help you with this.


If you are familiar with VLOOKUP, naming your data range on sheet 2 as 03_04
and on sheet 3 as 04_05 then the formula in sheet1!b4 would read:

=VLOOKUP(C1,03_04,2)

in sheet1!c4 it would be:

=VLOOKUP(C1,03_04,3)

and so forth