Data Validation comment automatically expand range

Hello, I have a list of names that get updated from time to time when new supervisors start working. The names are listed in a Table that will automatically assimilate any new entries entered below the last entry(Thank you Leila Gharani ). There is also an event code that will automatically sort those new entries within that existing list after they have been entered. My Table starts in cell U8 with the supervisor header and U9 begins the actual list of names. I am looking to make the worksheet a little more user friendly and wondering if it might be possible to have a data validation comment whose cell range will also expand as new names are entered just as the table range auto-expands. So if we had our last supervisor name in U28 for example, our data validation comment range would be from U9:U28. If we add a name to the list and now are at U29, I would want the DV comment range to update from U9:U29. Not sure if this is possible and is a VBA solution or if it would be a non-VBA solution?