Search & match more than one worksheet and matching cells.
 

Here's my current formula:

=INDEX(abc!$A:$F,MATCH([2006.07.08.sold.xls]main!D70,abc!$A:$A,0),1)

In this workbook, I have the following worksheets:
abc
def
ghi
jkl
mno
pqr
stu
vwx
yz
0_9

So, my formula as it currently is will match up a title that starts with a,
b, or c. But, I need it to do two more things:

1) I don't know what the title is so I need it to search all the worksheets
(listed above) at once.

2) The cell it's matching contains the title but there may be other words.
Is there any way to get it to match up? For example, the title is 'TIME' but
the cell it should match up in [2006.07.08.sold.xls] with contains 'TIME
Magazine.'