Excel 2007 : Need help on merging two excel sheet

[devtech]

Guys,
I need a help on merging two excel sheet,please find the description below.
I have two excel sheet named mol.xls and code.xls.
At mol.xls the column header are activity,element,comment,owner & version.
And at code.xls the column header are-owner,total,added,deleted & changed.
I need to merge the sheet code.xls to mol.xls with refernce to the key as "Owner".Like for the owner n.vakkalagadda it will serch the code.xls and copy the data from it and paste into right at mol.xls with the header "total",added,deleted & changed.
Please kindly reply if any suitable solution,macro or Vlook up.I have attached the sheets and the result sheet(what I require) for your reference.

Please kindly help me out