Merge data from 2 sheets into 1

I need a formula that will search sheet 1 column A for all part numbers, return them into A1 to A-whatever on sheet 3.

Then look up the price of that part number on sheet 1 column B and return in to B2 to B-whatever on sheet 3.

Finally, look up the part number that is now in A1 on sheet 3 and search sheet 2 for it, when and if its found return the weight of that part in C3 on sheet 3.

Basicly end up with sheet 3 showing the part number, price and weight.

See example if needed.

Thanks all. BVG