How do I combine some info from sheets by a certain criteria into one sheet in excel

[pips8885]

I working on creating an excel workbook that will help price match to other companies that sell the same product as mine does. There are 4 tabs with each tab being a different company. Our sku is column A, vendor is column B, Brand is column C, Model is column D, Color is Column E, Color 2 is Column F, Our Cost is Column G, Our Selling Price is Column H, eye size is Column I. That is all going to be the same on each tab. Then Column J is going to be the link to the other companies site, Column K is the date that we price checked on, and column L is the price that our competitor is selling at. I would like to have a master sheet that will combine all of this information, but only the most current date that we are looking at. Maybe have a dropdown that chooses the date, so we only get those prices on that date from the competitors.

Any thoughts on how to make this work would be appreciated.

Thanks!
Pips