Hi All
I am working on a price list with the following:
•Products are grouped per product category per worksheet and each containing about no less than 2000 lines per worksheet. I have total of 9 worksheets. (Each worksheets has formulas like currency conversion, markup prices etc.. to arrive to a retail price)

Question:
I need to create a summery sheet for most popular products.
How do I get excel to search the entire workbook and return the value on a designated cell, so that I have the price a specific product in the summary sheet and me not to do search every time and I can also print a simple pricelist say for a smaller customer.
Simple English is very much appreciated as I am not a very technical person.
Thanking you in advance.