Vlookup

[ezteze]

hello all,
so i have a few excel sheets that have information on them. each excel sheet is an purchase order. in them it has all item information with sku cases QTY unit QTY and pricing and more. so i have a few excel sheets each one is a diffrent order for a diffrent factory. what i want to do is create an excel sheet that i can combine all the info from all sheet into one master file sheet. so what i want to do is a v look up to grab information from the individual excel sheets into my master one

 

[CyrusTheVirus]

Can you please provide an example so the viewers can see?

Perhaps use two sheets of data and one sheet of the master file showing your expected results.