Searching through several sheets in a workbook

[Tom Atkisson]

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.

 

[Tom Ogilvy]

What stays the same? The tab order, or the sheet names.

If neither, how can the sheet be differentiated from the others. They
don't contain any formula, perhaps and the others do?