Another Indirect.ext question

[cav~firez22]

the formula im using is.

=INDIRECT.EXT("'[Weekly Collections Summary.xls]Collections'!$g$11")

I want to be able to just drag the cell to copy the formula, so the next one is H11, then I11, J11, K11, and so on.

is it possible?

 

[Oaktree]

Try:

=INDIRECT.EXT("'[Weekly Collections Summary.xls]Collections'!"&CELL("Address",G11))