Excel 2007 : Moving rows when date entered in a column

Hello all, I am pretty new to Excel 2007 and I'm hoping there is someone who could offer me a simple resolution to my problem.

I have a very simple worksheet to track completed projects, and I want to move the entire row when a final date is placed in the worksheet, ie on project completion. I need the entire row to move to another worksheet on the next available row, and the rows on the initial sheet to move up etc

I have been trying to do this for a while and had minor success, but as yet the solution has eluded me, does anyone have any ideas?

Thanks