Formula to Copy Column and Paste in new Worksheet in Ascending Order

Hi Guys.

I need a formula to copy a column from my "Master" worksheet to a new worksheet and paste it in ascending order. I need to keep the Member Number and First name also to match the new order of the column. If possible, I would like to keep the formula to one cell and not have to create new columns next to the existing columns. I have a user form that paste data in those cells and I don't want to have to recode the user form.

Please find a attached an example file.

Thanks.

Drew.

Any help would be appreciated. Thanks.