Microsoft Excel - Updating worksheet with new data

Ok...So every week I recieve an inventory status worksheet that consists of approx 7000 items.
There is approx 12 columns of data for each part number (on-hand,price,usage,etc...)

I am responsible for only a portion of these items (approx 1500)

When I get the worksheet I apply various filters using auto filter to get only what I need.
Then I sort it and format the cells so it's easy for me to work with.

The problem is that the data is frozen in time for the balance of the week.

I need a way to update a few columns daily with live data.

I pull the live data down from the main frame as an new excel file.

More specifically:

The first column is the part number and the columns i need to update are ONHand Inventory, Open sales orders, and Open PO's

So I need a way look at each part number and pull the live data in to the 3 columns that corresponds to that part number

Thanks

Create three new VLOOKUP columns in your formatted worksheet.  E.g., if the new file from the mainframe is named NewData.xls, both files have the part number in column A, and the OnHand Inventory is in column D of the new workbook file, with your formatted workbook open, open the NewData workbook and then switch the window back to your original file (Alt+W,2).  Then enter a formula like this in the second row and the column for the updated quantity:

=VLOOKUP($A2,[NewData.xls]Sheet1!A:Z,4,FALSE)

You can then copy that down your range of data (select the cell with the formula and double-click its fill handle).  Create similar formulas for the other new columns, changing the column postion (4, in the above formula) to correspond to the column with the value being looked up.