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
another worksheet row. I want to use that cell content to access the named
worksheet and populate a cell in the same row of the first worksheet. For
example, in worksheet A the content of cell A2 = B. I want to populate cell
B2 in worksheet A with the contents of cell B200 in worksheet B (the content
of A!A2). Then for other contents of column A of sheet A, Bx will be
populated with the contents of B200 of the sheet named in Ax where x is the
row number. The INDIRECT function does not appear to work in this case but
maybe I am formatting it wrong.

Thanks