Help with sorting rows by date and moving to archive sheet when cell marked "yes"

[kheiple]

Hello! I have a spreadsheet I am working on from work with will contain lost of rows of data and users will continue to add to it daily. I am needing the rows to sort by date oldest to newest on both the "regular Call Backs" and the "Escalation Call Backs" sheets. I currently have this happening on 1 of the sheets however when entering a new row as soon as a date is entered it is sorting which causes having to scroll to find and finish the entry. I do not want it to sort until the user has completed entering their data. A button to click would also work for this rather than auto sorting. I also need these same 2 sheets to move a row to the "Archive" sheet when column K is marked "YES". I would like both sheets to move to the same "Archive" sheet and add each entry from top to bottom on next available row while deleting the row once moved so I do not have blank rows on the sheets there are moving from. I have a icon which has Archive marked on it which woulkd be great if I could just click that and it moves the rows needed that have been ,marked "YES". Any help would be greatly appreciated. Here is the file Im working with

https://1drv.ms/x/s!AmTgeGiJReSZdso0uQ7VcIKHOrY

 

[pbornemeier]

Got:

This item might not exist or is no longer available
This item might have been deleted, expired, or you might not have permission to view it.
Contact the owner of this item for more information.

When attempting to download your file.

Use Excel Jeanie (see link in my sig) and copy your code to your reply.