Excel Dynamic USELIST with data validation

This does work to an extent but if any data is added and or a new item to the first column and you add the column to the list you will have to add a new NAME into the NAME MANAGER before that information can be pulled and utilized inside the spreadsheet.

I am attaching another spreadsheet that I took this idea from, but again I cannot find what the difference is and I am sure it is something I am overlooking and if you will notice in the NAME MANAGER there is not a name for each individual column.

Like I said I am sure it is something I am just overlooking but for some crazy reason I just cannot see it.

Thank you again!!