Insert Column in alphabeticall order of name on next sheet

[ufopilot3]

Good Day,
I have a matrix I would like to automate once a new name is added to the list.
I have attached a shortened sample (many sheets, rows, columns and macros deleted)
The name and information is added in one worksheet, then I need to "open" a space between the columns where the new addition would fit in
automatically (insert column) and have the name as it appears in colomn AJ in the list copied to the matrix in the new column in row1.

There are some helper columns in the list to express who still needs to be added (ADD) and which column they should be in. but I do think those may become obsolete once I can automate this process.

It would be a great time saver, and tool for handing the job over to another person in the department if I can get this more user friendly
Thank You For your time
P.S. -this would be a great project for ACCESS, but we do not have it available to us (yet)