Dependent data validation with dynamic named ranges

This seems to be rather annoying.

I am unable to use dependent data validation lists using the INDIRECT function when the initial named range is a dynamic one.

See attached.

The named ranges 'Men','Women','Children' are all dynamic based on number of entries in each column order to accommodate a growing list, whilst also not having blanks in the dropdown (hence I haven't used entire column ranges). The named range 'test' is a static one.

Column H has a dependent data validation based on entry in Col G. This works for the static list, but not the dynamic one!

Any workarounds? preferably no VBA