How to cut and paste into another worksheet a row marked complete?

Hello all,

I think this must be a simple request. I have never used VBA in my life, but in Excel 2013 workbook titled "To Do", in my worksheet titled "Tasks" is a list of tasks. In column A (titled "Complete") is a dropdown list where a person can choose either nothing, or YES, for when a task has been completed.

the range of Tasks is from A5:I901

Once they choose Complete and save the worksheet, I would like:
1) this row to move to another worksheet in the same workbook titled "Complete"
2) the row to be deleted from the initial Tasks worksheet
3) all other rows shifting up so there are no blank rows

the way the Completed tasks should be sorted, I don't care, as long as it is systematic in where the next Completed item is placed (either each one pasted after the last one completed, or the most recently completed item showing at the top of the Completed list - no preference.)

4) and then I need to know how to save this as a macro and make it run.
5) I'm hoping other users will open the workbook and all rows marked complete the last time someone was in the sheet will be moved automatically without having to do anything to run the macro manually.

Thank you in advance!

Dear SKTNEER. THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! What a wonderful Monday - I turned on my computer at work, and my problem was solved. I had to make one edit, where the dropdown list shows YES instead of Complete, so once I replaced

Set ws1 = ThisWorkbook.Sheets("Complete")
with
Set ws1 = ThisWorkbook.Sheets("YES")

it worked perfectly. THANK YOU THANK YOU THANK YOU!!!!!!! I am so grateful for your time.

SKTNEER, One more question. If I move the data in Column A to Column H, I am unsure about how to adjust the VBA code. Wherever you had "A" in the code you gave me, I changed it to "H", but nothing happened.

yep, that works! do you accept payment as a thank you for your advice?

OK, well thank you again then.