I have four pages in a workbook. Each are exactly the same with different data. I need to find the "part number" (which is in a column) on each page and have it bring back the lowest cost (which is also a column). So, it looks for all part numbers across the worksheets and brings back the lowest cost. I also need for it to bring the "start" and "end" dates from the worksheet it found the lowest cost, but it is at the Header level.
We will have a master table of all parts on the first worksheet. then it looks ant the other four. More worksheets might be added.
If the part number cannot be found on any worksheet, it needs to bring in N/A.

I was going to do this in Access, but though Excel might be better because of the "Header" rows.

Thank you!