at present this formula is sucessful:

in cell G7 I have:
=INDEX('[012007 Cash.xls]Day4'!$T$150:$T$354,$C7+1-150,1)

In Cell G4 I have text Day4

How can I alter my formula to read the G4 value in place of the hard-coded
Value?
something like ,,,,

=INDEX('[012007 Cash.xls] Indirect($G$4) '!$T$150:$T$354,$C7+1-150,1)
??
Any help appreciated..