I have one workbook for sterling silver jewellery. Within the workbook I have
several suppliers who each have their own worksheet with their products
listed and prices. I need to compare the prices from each supplier for one
item.
An example: Each supplier has an item called "Frog Earrings" and without
going through each worksheet how to I get the price from each supplier for
the "Frog Earrings", for comparison? Is there a way to do this?

Thanks