Is it possible to write a formula which retrieves a value from one of a number of avaliable sheets based on the values of different cells???

Ie. This formula:

='sheet1'!AC38

Becomes something like:

='B2 & " " & C2'!AC38

I have two variables, A and B plotted horizontally and vertically and Bassically, I need to populate a grid with values from a whole host of sheets in the same workbook.

I could reference them by hand but, it would take ages and i may need to change some of the B titles (and the results sheets) at some time in the future so, if i can write it into a formula that would be better.

Any thoughts gratefully recieved.

Cheers.

Dave