Way to retrieve values from a dynamic named range?

It shouldn't do - note the RefersToRange, not RefersTo.

If you assign the value of a multiple cell range to a Variant, you always get a 2D array. If you don't want that, then Transpose it.