Combine two excel sheet into one

Details

I need help combining two excel sheets into one sheet or database, both sheets have a unique key with is either three or four letters....some of the keys double on one sheet...so a lookup of sorts is needed to find the data.