I have a workbook with 10 sheets. 5 sheet have product data in them. The
others are vlookup data, a blank formated sheet for future use, and a print
sheet i am going to use for this problem. Each sheet has its own unique
name.

Is there a way to search the 5 sheets without having to list each by name,
something like searching cells

for each cell in range

and yet not search the other 5 sheets?

For example, there are sheets named Apples, Oranges, Pears, Bananas, Grapes,
Prices, Weights, Blank, PrintList. Can i search Apples thru Grapes and not
Prices Weights Blank or PrintList?

I hope I made myself clear. Thanks in advance.