Pickup Sheetname Named In Cell

[Delta Star]

I'm using the formula below but need it to pick up the sheetname that is named in a cell rather than have it in the formula. The sheet name will appear in cell A1.

Can anyone help?

=INDEX('Weekday'!$C$5:$CD$86,MATCH($B12,'Weekday'!$B$5:$B$86,0),MATCH(C$10,'Weekday'!$C$3:$CD$3,0))

 

[p45cal]

checkout the Indirect function perhaps?

 

[Andrew Poulsom]

tRY:

=INDEX(INDIRECT("'"&A1&"'!$C$5:$CD$86"),MATCH($B12,INDIRECT("'"&A1&"'!$B$5:$B$86"),0),MATCH(C$10,INDIRECT("'"&A1&"'!$C$3:$CD$3"),0))