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.

Hi Mehmetcik...thanks for the quick reply. I tried to follow your instructions but I cannot get it to work. I deleted the IFERROR formulas on the "Closed" tab, but that didn't seem to work either. I also noticed there was coding in Module 1 which I no longer needed so I deleted that as well. Any suggestions on what I may be doing wrong? Thanks again for looking at this.

Works perfectly....thanks so much

One last question....Currently I have coding on the first tab that will auto sort the sheet once it is activated (select closed tab and then go back). I tried pasting this coding on the "Closed" sheet as well but it didn't work. I also tried pasting it into the "Worksheet" coding but still no luck. Is there a way to have the "Closed" sheet auto sort alphabetically by Column A as well?