I have multiple spreadsheets that I want to move certain information from to
get all my info into one spreadsheet. Is there anyway to search mutiple
spreadsheets by a column like "Part Number" and tell it to retrive another
column like "Qty" then post it into a corresponding column in another
worksheet by matching "Part Number"??