Bob: Thanks for your quick reply and soory about the confusion...I will need
to remove the term "wksheet name that I specify" from my inquiry...Hope this
helps...Thanks!

"BMW" wrote:

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.