VBA: Dynamic List from same column on multiple sheets

Hello,

I am back again looking for more help.

My question is how to create a dynamic Master list on a master sheet that just grabs all the information from the same column on multiple sheets and creates 1 master list of all the values.
Looking for 2 solutions:
1 - just basic pull all the data into master list excluding blank rows
2 - same as above only sorted

The actual excel workbook can have up to 50+ worksheets but the values will always be in the same column.
The number of rows can also be different but never more than 1000.

I thought this would be relatively simple but I was not able to google it. I tried some filter and indirect combinations but I could not get these to work for me.
This will be used primarily by someone that is not familiar with excel so hopefully nothing too complicated.

Any help would be appreciated. TY
Gray.