Create multiple ranges based on an index of values that are also used as range names

If you design each area with no blank rows within the datablock, this becomes very easy to do. You willing to make that change? Just leave blank rows between sections...