I assume you are using row 1 for headings (as you indicated). In cell B2 on Sheet1, enter
=VLOOKUP(A2, Sheet2!$A$2:$Z$99, 2, FALSE)
$Z$99 to include all the data in Sheet2 that you need to access (i.e., it should be at least the lower right corner of the data). The second-to-last parameter is 2 to access column B in Sheet2; for column F, use 6, etc. Drag this formula down as many rows as you need to cover.