Sorting by column issues with expanded selection

Hi, first time on here and also first time working on vba's and have become stuck on what is such an infuriating issue

I have a workbook with multiple worksheets for creating team rota's from a master .csv file. The steps are:

1) a manager can pastes the csv file onto one sheet
2) the manager then enters the start date of the week into a field on the main control sheet and hits the run button added.
3) this is then copied by a macro to another sheet so that the vlookup's can pick up the data and sort it into team members
4) a new sheet is created and the values/formatting is copied onto it from step 3
5) the new sheet is renamed to the date entered on step 2 and opens so that it can be viewed and printed.

The problem I have is that on step 3 I can get the information to copy over but I can't get it to sort it alphabetically by column b with an expanded selection.

The worksheet to sort is called "Data" if you need to know.

I have set the rest of the steps up using borrowed code or recording macro's so getting really stuck.

Any help will be appreciated.

Sorry, I meant to include the code I have so far:

Please Login or Register  to view this content.

Can I just add one of your examples HeHoBe?

Thank you Holgar, however the data source has a few empty rows in the middle which will stop it. Can you advise how I can amend it to define the range?