Vlookup - How to get it to search and update multiple records

I have a database in the form of an Excel spreadsheet with a 'primary key' in COLUMN A. There are corresponding dates and shipment statuses, etc in the following columns. I would like to take vlookup and use it to find the matching 'primary key' or 'tracking number' in COLUMN A in another worksheet and bring the corresponding columns in the same row into the worksheet I am updating. Simple enough right? Except there are over 2000 rows to update. Is there a way to vlookup multiple rows in column A so that they update without running vlookups on each individual line? Basically I need to update shipment statuses and projected delivery dates.

PL See attached file.MAIN Sheet contains data.Array formulas are available in sheet2 and sheet3.

How do I get that in each cell without adding it to each cell individually? What is the process?

Sorry I did not understand What you want. This is only example file.If formulas are not required Macros or worksheet events can be used.