Copy & Delete Rows to Another Sheet

[cindy1971]

I have a spreadsheet named GTD Week #XX with approximately 6 columns and multiple rows. Upon entry of a specific value (Done, Complete, whatever) in the right most column, I need the row to be deleted and moved to a sheet called "Log" in the same workbook. I need to be able to copy this sheet and change the week # each time, but all deleted rows should be added to the same sheet, "Log."

I know it's a lot to ask but can anyone help me with this?

Thanks,
Cindy