The Purge

I have an excel spreadsheet for my work that I have a couple of macros to move rows from 1 sheet to the next.  I can get it to work moving from one worksheet, but not both of them.

I want to move Pending invoices to the pending tab.  And then I want to move complete invoices to the closed tab.

I'm not good with programming so I used an online tutorial and got the code to work from the pending to the closed invoices tab, but I can't get it to work from the Open to the pending tab(it just deletes the tabs from the open but doesn't paste into the pending).  

Any help would be appreciated!

Bah, I can't attach a spreadsheet...  If can help and is bored, I can e-mail it to you...

Thanks!!