I'm trying to create a formula that will do the following:

search through all worksheets (either in the same wkbook or a different
wkbook)...for the wksheet name that I specify, and lookup a value from a
reference cell or range.