Need macro created in excel to merge data between excel file

IN PROGRESS
Bids
3
Avg Bid (USD)
$30
Project Budget (USD)
$30 - $250

Project Description:
I need a macro created in excel or a simple software developed that can merge data from 2 excel sheets based on criteria. I have a main excel file that has 3000 part numbers with titles, categories, and descriptions. I then have another excel file that has titles, descriptions, pricing, and part numbers. I want a macro created that will search the part number field of excel file 1 and copy corresponding titles, categories, and descriptions from excel 2 based on matching part number. I want someone that is experienced in this and possibly can create software that i can set criteria to output the file in a certain format. Should all be a CSV
When responding please indicated if you will create a macro for excel, or if you will develop a custom .net software.

Below is an example file. Typically the partnumber will not be in the same order and will be mixed up.

Skills required:
C# Programming, C++ Programming, Data Processing, Excel, Visual Basic
Additional Files: sheet2.csv sheet1.csv
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 1 days
Hire microk
$ 30
in 1 days
Hire vgrichards
$ 30
in 1 days