So I have multiple lists, Column C may have 5 items, Column D may have 3
items, Colume E may have 12 items. How do I consolidate all of the items
listed in C, D & E into one list? Once that is done, I would like to then
resort the one list into an alphabetical list. Perhaps with a macro & a
button on the screen to activate the macro?

Let me know.

Thanks!