Indirect Function returning REF# when comparing a single cell across a sheet range

Attached is my situation. In sheet A, cell A1 I have a function that looks for the largest value in cell A1 on sheets B through C. It works properly.

I would like to be able to make that range (B through C) referenced from input cells, in the file shown as B2 as start and C2 as end. These simply contain B and C.

My attempt among many is shown in A2. That is LARGE(INDIRECT("B2"&":"&"C2"&"!"&A1),1)
however it always returns a REF# error. After checking the microsoft REF# errors, I have determined that it does not match any of the criteria for REF# they discuss. Any suggestions?

Control+shift+enter, not just enter:

=MAX(N(INDIRECT("'"&B2:C2&"'!A1")))

LARGE(INDIRECT(B2&":"&C2&"!A1"),1) this way
i 've never heard that LARGE can work so

Originally Posted by iestimated

array solutions tend to take a long period of time, and for the number of times i am doing this on my spreadsheet i would like to avoid doing so....

What you really should avoid is having zillions of INDIRECT calls...

What is the reason for LARGE(INDIRECT(B2&":"&C2&"!A1"),1) not working?

"B:C!A1" is what INDIRECT is fed with. This text does not construe a reference INDIRECT can evaluate.

The suggestion I made feeds INDIRECT with text values {"'B'!A1","'C'!A1"} INDIRECT can interpret as proper references.