Need to copy a row from Sheet1 to Sheet2 then auto delete from Sheet 1 based on Column G

Hello Everyone,
I have an excel spreadsheet (Excel 2007). I need to copy the entire row from the Sheet labelled "Master" based on the comment placed in column G labelled "Status". If the comment states "Closed", I want the entire row to be transferred to the sheet labelled "Closed" and then the original row from the "Master" to automatically delete.
Currently my excel file will transfer the information as required but it will not delete it from the "Master" tab. On the sample it is Row 8 on the "Master" tab that I want to have auto delete.
Does anyone know how I can do this? Any help is greatly appreciated.