Macro to sort list of names alphabetically, then into a table with static columns&rows

Hello,

I have a list of names that is dynamic (a few are added or removed each quarter). I need help writing a macro that sorts these names alphabetically and then inputs them into a table with a fixed number of columns and rows under each column (3 columns with 50 rows in each column). The names should fill each column before starting to list in the next column. Thank you!

could you be so kind to include a sample with the data and the expected results?