I am looking for something that is very similar to this solution, but I need to be able to search an indefinite number of worksheets.

I am new to this , but I am trying my hand at scripting because I do not think the formula approach will work for my problem.

Basically I have multiple workbooks that need to be searched and displayed. I was able to run a script that consolidates all workbooks into on each having their own worksheet.

I now need to figure out how I can search each of these sheets. The first issue is that the number of worksheets and their names may be different each time I run the consolidation script.

How can I create a script that will perform behave the same as the formula used in this solution but search an indefinite number of sheets with unknown names.

Thanks
Jim