Fetching data from another WS

Hi Everyone,

I need to perform a task and wanted to ask someone if it can be done.

I have a worksheet that is used for inventory.

The worksheet is being used to build an parts catalog.
Items are broke down by catagory.
There may be only a 100 - 500 parts in the sheet and all of them are in the same catagory.
So in other words there is a sheet for every catagory.

Example:Sheet maybe named "Hand Tools" another may be "Power Tools"
You get the ideal..

It has about three columns. (could be more but does not matter)

Col A- Part Nbr
Col-B- Description
Col-C- Cost

We will call the catagory sheet -- "Sheet A"

I have another worksheet that has the same information but it is the complete inventory about 10,000 items.

We will call this sheet -- "Master"

Now that I have said all of that, this is what I need to do.

Look for "Part Nbr" in "Master" that matches "Part Nbr" in "Sheet-A"
Get the "Cost" of that "Part Nbr" (from the column were it is at) and move that cost to "Sheet - A".

I know that this is a bit worded but I want to be sure that it makes sence.

At least I hope it does!

Just some how loop through the hole sheet and get the data .

This might be easy but I need some help please.

Thanks for your time,

Jim