Moving records between sheets

Hi,

We have an excel sheet with user subscription details. I need to know if we can transfer the records for which subscription is due automatically to another sheet [sheet2] so that sheet 1 will always have valid user details.

Now we are manually removing the entries, which is really painful... pls help..

Thanks,
Madhu

i guess this should be pretty simple... just that i am new to application programing... can someone throw some light ?