i really need help please - VBA

I am working with a large excel database in which i am logging the status and training for our volunteers. We have a column where we choose the status of the volunteer, in this case i want the word "Leaver" to cause the whole row to copy and paste onto a different sheet. With the attachments this would be the change of status from sheet "BEF" to "BEF Leavers" i have managed to do it previously but it always deleted the current data on the leavers sheet, i wish for it to copy to the row underneath. I know it's possible but i constantly hit an error with it and a DEBUG message which is making me go mad and it's not something i am confident with in excel.
I would like it to be a macro button but that seems to be so far off being possible at the moment so am more than happy with it being a run script.