I have one string that is dynamically built with existing ranges across multiple sheets. All these ranges are exactly the same structurally but with different data. I want to join them all into one master table for further processing. One example of such a string:
The path above is a result of the following formula:
I want to use the result of this formula with some function like INDIRECT. The problem is that INDIRECT does not support arrays.
Is that possible?