In the main sheet, cell B2, put this formula -
 =vlookup(A1, Source Sheet!A:B,2,0)