Generate cross sheet reference names using formulas

LeoT

Instead of manually typing the reference name, it would be extremely useful if it could be allowed to generate the string into the curved brackets using a formula. In the same way it would useful also using Summary sheet fields in it.

Example:

=INDEX(COLLECT({Sheet1_Name}, {Status}, "Enrolled"), 1)

could be

=INDEX(COLLECT(("{Sheet"+[Sheet number]#+"_Name}"), {Status}, "Enrolled"), 1)

or

=INDEX(COLLECT((JOIN(Ref1:Ref3),""), {Status}, "Enrolled"), 1)

where Ref1 Ref2 Ref3 contain the part of the string to build.