There are a few steps here. First I'd recommend you get both
worksheets in the same workbook. Next, you'll want some VLOOKUP formulae
to go to the second list and pick up the data  you need automatically.
You can read about how that is done here:

http://www.grbps.com/Excel6.pdf

Then, you can lose all the formulae and just keep the combined data.
Select the whole sheet, copy to the clipboard, then
paste-special-values.