I probably should have been more specific now that I think of it. I understand what to do and the logic behind it, I just don't know the syntax. The person who gave me the task doesn't know VBA either I believe. This copy paste thing isn't a one time deal either, the WHOLE macro is. Copying and pasting is just a part of the macro. Also, there are 7+ tabs that will be copied from and at least 1 copy/paste per tab. So if you could, could you give me the syntax by chance? To be even more clear, I need it to paste to a specific row of my choosing, and that row will increment by one after each paste, if that makes sense.

In that case, my previous comments may still apply and, given your confessed lack of vba experience, that seems even more likely. All the same, though, without knowing the scope of the project it's impossible to say for sure.
There really isn't anything generic about the code to do this. I could post some arbitrary code copy for copying & pasting to an active cell, but I doubt that would get you much farther. You would need to provide a whole lot more detail, especially: how the code is to identify the sources to be copied in each case (e.g. you say you have 7+ tabs, so how does the code identify which tabs to copy from and where to find the data on those tabs); the order in which the copy/paste for the different sources to occur; whether the source format is to be retained; whether there are formulae in the sources that are to be retained, or just values; etc.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]