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

Please Login or Register  to view this content.
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