Im trying to pull information from another sheet when i enter data. for example

A B C D E F
1 LMPASC01100CC 83 110 12 12 877407005637
2 LMPASC07100CC 76 110 12 12 877407005668
3 LMPASC0789CC 72 100 12 12 877407005651
4 LMPASC0789QC 72 100 12 12 874407005643


I INPUT

NEW SHEET
A B
1 877407005668 NEED TO PULL A2

SO I NEED TO MATCH A1 WITH F1:F4 AND PULL CORRESPONDING PART NUMBER IN A