Move sheet. delete row

Hi,

I have date in a number of rows. The data relates to whether a policy is valid or expired. If a policy expires, I need the row to remove itself and go onto another sheet.

Please see zip as a guide.

Any help would be appreciated. I have trawled the forums and not been able to piece anything together.

thanks