Sheet3, A1:

Formula: copy to clipboard
=VLOOKUP(Sheet1!$A1,Sheet2!$A$1:$Xx$Xx,COLUMN(B1)-1,0)
Change $A$1:$Xx$Xx to accommodate your full range of cells, then copy right and down as far as needed.