this will give you what you need, buty you will need to changethe references if your range on the data sheets change..

=VLOOKUP(A2,INDIRECT(A1&"!A2:e14"),2,FALSE)

Change the ,2, to 3...4 as needed