putting cell text into another cells furmula

A1 is the formula which works

A1 =INDEX('G:\Excel\[Tester Boiler Feedwater and Deaeration System Mapping Validation.xlsm]Tasks & Questions Input'!$B$2:$B$101,COLUMN(A1))
A2 G:\Excel\[Tester Boiler Feedwater and Deaeration System Mapping Validation.xlsm

how would i get the value in cell A2 into that formula where the red is?



thanks in advance

You can use the indirect formula for that sort of thing:
A1 =INDEX(Indirect("'" & A2 & "]Tasks & Questions Input'!$B$2:$B$101",COLUMN(A1))

I git an error saying not enough brackets, so i added another bracket to the end.......

then i got the error "you have enetered too few arguments"`

=INDEX(Indirect("'" & A2 & "]Tasks & Questions Input'!$B$2:$B$101",COLUMN(A1))

so then i put a bracket here and stilll have an issue

=INDEX(Indirect("'" & A2 & )"]Tasks & Questions Input'!$B$2:$B$101",COLUMN(A1))

Try
A1 =INDEX(Indirect("'" & A2 & "]Tasks & Questions Input'!$B$2:$B$101"),COLUMN(A1))

Note - you may want to look at the ], if it isn't in your A2 cell it needs to be there but maybe it is?