One Spreadsheet multiple tabs; when data matches in one column, import data from another c

Hello All,

Thanks in advance for the help. I have a spreadsheet with multiple tabs that I need to combine certain data into a single tab. I am fairly certain that I need to perform a Vlookup, but cant seem to get it right.

My first tab "FIS Web Pricing will be my master file. Column A in each of my sheets contains a part number (unfortunately trailing spaces might be different). When this part number matches on another sheet, I want to import specific matching data from another column. There are extra part numbers in sheets other than the main "FIS Web Pricing" Sheet that I don't need. Therefore the data is not in order and cant simply be copied over.

Here is the Data I need to get into Sheet 1 "FIS Web Pricing from the other sheets:

When data in column a "FIS Part Number" in sheet 2 "Weights" matches data in column a "FIS Part Number in sheet 1 "FIS Web pricing, then I want to import the unit weight (column B) from the "weight" sheet to the "FIS web pricing" sheet under "unit weight" (column b).

EDIT - I figured out how how to get the weights over using "=VLOOKUP(A2,Weights!A:B,2,FALSE)" I still need to get the other 3 columns "List Price, FIS Cost, and Sale Price 50%" imported from Sheet3 and Sheet4.

I want to repeat this same procedure by matching coulumn a, my part number and exporting 3 corresponding columns from two other tabs.

When Column a (FIS Part Number) in sheet "Sheet3" matches column a (FIS Part Number) in the "FIS Web Pricing Sheet" I want to import the "List Price, FIS Cost, and Sale Price 50%" columns. This process will be repeated for the sheet named "Sheet4".

Any help is greatly appreciated and I can provide further clarification.

The file is too large to upload.