Note it’s possible for you to refer to anamed rangein a formula without using INDIRECT.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
Indirect named range different sheet
To reference a named range on another sheet, you can use the INDIRECT function with the required sheet syntax. In the example shown, the formula in D6 is: =SUM(INDIRECT("'"&B6&"'!"&C6)) Which returns the sum of the named range "data" on Sheet1.
