I want to union a few named ranges dynamically, while avoiding the use of Google Apps Scripts as much as possible. The number of named ranges can vary, so any references to them has to be dynamic. For instance:

Google Sheets, attempting to define multi-cell named ‘constants.’

Suppose I have a named Range in Googlesheets as MyNamedRange with definition as C1:H25