inserting worksheet names into a formula

Hi all

I have the following formula which works perfectly, but I'm having problems trying to make it more dynamic...

i.e. the formula arrays used in the index are currently fixed to the worksheet 'ABB Aluminium'

I would like to get this to refer to a cell, say A8, which would have the name of the relevant worksheet in.

=IF(BE8<=55,INDEX('ABB Aluminium'!$B$8:$K$29,MATCH(BE8,'ABB Aluminium'!$B$8:$B$29,0),MATCH(CA8,'ABB Aluminium'!$B$8:$K$8,0)),"-")

I've tried to use INDIRECT, but I can't seem to get it to work...

Thanks in advance

Hello
The following INDIRECT reference should work for your first range:

INDIRECT("'"&$A$8&"'!$B$8:$K$29")

Amend for your second range.

Hope this helps.
DBY

Thanks DBY, that's perfect.