VBA to copy data from multiple workbooks to Master Workbook

I have 4 workbooks which each contain a sales log. 1 is a Master Log and 3 are maintained by separate users. I am looking for the easiest way to update the Master Log with the data from the other 3 workbooks that is fast, user friendly and avoids data being corrupted by the users.

Process:-

On running Macro open alert with information - ok / cancel
Go to "Sales Log" unprotect sheet, show all, clear all filters, sort Range ("B3:B100") ascending
Open Sales Person 1 Workbook, go to 'Sales Log", unprotect sheet
Select "Range1" sort by ("B3:B100") Copy "Range1"
Paste Range1 data (values only) in Master Log Range1
SaveAs Sales Person 1 [date and time] .xlsm and Close [no alerts]
Repeat for Sales Person 2 and 3 Workbook
Master Log: Select "RangeALL" sort by ("H3:H100")
SaveAs Master Log [date and time] .xlsm and Close [no alerts] Attributes: Read Only
Close excel application

Please Login or Register  to view this content.

Hey Wotsup - Please put your code within code tags (as per forum rules)
Also, you have not explained anything here. Since i have worked with you on a similar thread, i know the requirement, but others will not. Please explain what you require.

All code changes given in bold.

Please Login or Register  to view this content.

Do you have a file that you can upload so i can test it? Otherwise, its a lil difficult to find out the bugs.