how to reference sheetname

[LAM Chi-fung]

Hello all, I have 3 work sheets:
sheet 1) Jan
A B C
1. 1 2 3
2. 4 5 6
5. 7 8 9
sheet 3) Feb
A B C
1 10 11 12
2 13 14 15
3 16 17 18
sheet 3) Result
A B C
1 Jan 1.4
2
3

in Sheet 3) (the sheet named Result) A1 is a "control cell", if enter
Jan, A2 will become
=Jan!A1*B1
while enter Feb, A2 will become
=Feb!A1*B1

I try use A1!A1*B1 and index without success (i.e.
(index(A1:A1,1,1)!A1)*B1)
Can anyone help ? Thanks a lot.

Regds
LAM Chi-fung

 

[Frank Kabel]

Hi
have a look at INIDRECT
e.g.
=INDIRECT("'" & A1 &"'!A1")*B1

 

[JE McGimpsey]

Use INDIRECT:

=INDIRECT(A1 & "!A1")*B1