That would be "finding" not "looking up" in the sense that OP may be
referring to VLOOKUP or INDEX/MATCH or similar function.

In your case of "finding" you don't need to select all the sheets.

Just set Find options to Within: workbook.


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 15:19:02 -0700, TheTraveler
wrote:

I may be showing my ignorance here, but can't you select all the tabs and
then use CTRL F? I don't have 800 tabs, but I do this often. I am also
looking for specific values or text, not formulas.