Help with VBA to auto archive data

Hi all,

I've created a spreadsheet for our sales guys to list all their upcoming projects so that we can forecast material requirements and orders accordingly.
I have a main sheet (Pipeline) where they all enter the specific job information.
Each supplier has it's own sheet, and particular data from the Pipeline entry is automatically copied onto the next row of the relevant supplier sheet. I had help with this process, so don't really understand how the formula works to do this, and feel that there must be a better way to do this in VBA. However it's doing the job for the moment and I'm happy with that.
I also have an Archive sheet so our guys can remove old entries from the current Pipeline without losing the information.
I've adapted some VBA code from another answer I found on the forum, but I just can't get it to work properly.
I have a drop down box on the Pipeline sheet with Yes and No to choose from. If the person clicks Yes, that row is deleted from the Pipeline sheet and moved onto the Archive sheet. Similarly, in the Archive sheet there's the same selection, and if No is selected, the entry is deleted and moved back to the Pipeline sheet.
This is exactly what I need it to do, except that I can't get the entries to move onto new lines. If I archive two rows, when I go into the Archive sheet, only the last row is there. Likewise, when I return an item from archive, it always goes back over the last entry, not onto a new line.
I'm desperate for any help on this, and anything you can offer will be very much appreciated.

I tried to upload the file but it's too big.

Cheers Kay.