Google Sheets Formatting

I need the following changes made to this Google Sheet: [login to view URL] 1. in the cells under the priority column, i need a dropdown menu in each cell that allows me to select between: low, medium, high 2. if the item in the row is checked as completed, it should be moved to the bottom of the list (row 100 and below) 3. if the priority of the row is selected as high, it should be moved to the top of the list 4. if the due date is in the next 24 hours, the row should be moved to the very top of the list (above those things selected as high priority). 5. If I add new rows to the spreadsheet, the completed tasks should still always be at the bottom. This is the work I need done right now but I want to keep you on to make further changes on an hourly basis. Please don't make the changes unless I award the job to you.