Pick scattered entries from many columns and order them A-Z in one column

Hi guys

In the attached file, I have a large area of cells (blue), some of which contain words.
I need a formula or macro which will pick all the entries and group them in one single column (yellow one) without empty lines.
At the end they have to be ordered A-Z.
You can use several columns if needed.

Help would be appreciated... thanx!!