Google Sheets Help

Need some help with google sheets.
We have a spredsheet we use for tracking jobs in the workshop. We use a dropdown to prioritise these jobs.

Once the job is completed, we mark it completed and drag it down the page. Is there a way to automate this, so once "completed" is selected, that line automatically drops to the bottom of the page.

Hi sorry to say this doesnt seem to work and the line just remains where it is when changed to "completed".
This is on the third sheet of the workbook if that makes a difference to the formula.