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

Example.xlsmExample.xlsm

Hello, here is an example workbook with the data.

I manually created an index to assign names to each data set. Now I need to figure out how to keep the range selection dynamic, so when I get a different length data set, the code only encompases that range in the creation process.

I wanted to initially build a loop to test each value within the data set and return the first blank cell and use that as a reference, but I feel like there is a more efficient way to achieve my purpose.

Thank you for your help so far, any suggestions are highly appreciated.