Need to change address of named range as list is filtered

[excelschlub]

Hello - I have a list of hyperlinks that open a userform. Each hyperlink is tied to a unique row of data in the range. The hyperlinks each refer to a unique named range based on the data in that row. I need users to be able to filter this list in order to organize the rows in various ways. My problem is that when the range is filtered, each of the hyperlinks refers to the originally defined range which does not align with the row of data it is supposed to correspond to.

So, is there a way to get a named range or the hyperlink subaddress to change as a list is filtered?

Thanks,
Dave