INDIRECT or alternative?

Hi,

I am trying to make a reference to different worksheets within a formula based on the what text the user selects from a combo box.

The basic idea is to pull the data from cell A2 in a worksheet, as chosen.

I can get the text matching the work sheet name to display (in a cell B66 on a defined sheet) no problem using both below:

=INDIRECT("' '!$B$66") or
=(CONCATENATE("",' '!B66,""))

I can also get the data I need to display if I have another cell (C66) with A2 typed in with this:

=INDIRECT("'"&' '!B66&"'!"&' '!C66)

And also using this:

=INDIRECT(CONCATENATE("'",' '!B66,"'", "!A2"))

But what I then need to be able to is copy this formula across rows and down columns so that I can act on a whole grid of data and that's where I get stuck. Obviously =INDIRECT("'"&' '!B66&"'!"&' '!C66) doesn't do it as C66 becomes C67 etc and I lose the reference, and the final one is just text so doesn't copy and move the A2 reference.

Any pointers at this stage would be greatly appreciated!!

Thanks D

Hi Tony thank you for your quick reply, that's solved my issue straight away.

The quote marks were my fault as I was actually working in a sheet with one space for a name hence the multiple ' '!...I was going to change that before posting but ended up working til late.

Thanks again!

D