Dear all,
I was wondering whether there is any nice function I can to ensure, that an indirect(concatenate(...)) file path is automatically updating:

e.g. 
cell A1: ="Sheet2"
Cell A2: =INDIRECT(CONCATENATE(A1;"!B3:AC5000"))

so value in A2 is "Sheet2!B3:AC5000"
If i were to insert columns between B and AC in sheet 2 the concatenate function does not update (which intuitively makes sense).
However I was wondering whether there is any trick I can implement so that the cell-reference is updated, although it is written in a concatenate function.

thanks for any suggestinos.

cheers