Hi
Looking for a way to search thru the workbooks and find criteria and add workbooks that have that information in it.

Example:

Looking for Zebra in all workbooks

Return: Book1 Book3 Book5 (this to written into a cell of another workbook)

Note :"Return" indicating the Books that contain Zebra in it

Is this even possible ?

Thanks in advance