Bob,

That was quick and it worked. Mind explaining how you constructed this answer?
IE, what does each part of the function mean, particularly the quotes,
ampersands, etc?

Thanks

Bob Phillips wrote:
=INDIRECT("'"&A2&"'!B200")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

This should be simple but the functions that would appear to be the answer
don't work. I have a worksheet name that is contained in column one of
[quoted text clipped - 8 lines]

Thanks