Instead of pasting the info, maybe you could use a formula (or a bunch of
formulas):

Debra Dalgleish has some instructions for =vlookup() or =index(match()) at:
http://www.contextures.com/xlFunctions02.html

Wordgeek wrote:

Hello,
I need to create a worksheet that pastes the columns from other related
worksheets into the new worksheet by finding records that have a common "key"
record.

--

Dave Peterson