I have 4 sheets of data(sheet 1,sheet2,...) and 10 columns of data on each
sheet, each sheet starts with column A as the part number and 10 as a price.
I have a separate sheet called summary, that has a list of part numbers in
column A, i want to match this list to return the values that are in the 4
sheets of data.