ok, so this seems like it should be easy to pull off, and I can get it to copy and paste one sheet to another, but alas when I try to get it to do both sheets I fail miserably. Any easy way to do this?
I had deleted the code I was using put it was in effect copying Sheets.("Pipeline") and pasting it into another sheet - Sheets("Pipeline3". But to answer your question, yes, I'm trying to get the first sheet to post to Pipeline3 starting at A1 and the next sheet to post on the first available row after the first paste.