You can retrieve the value from specific columns and merge them onto another
worksheet by using the =vlookup() command.
=vlookup(a1,sheet2!$a$1:$x$9999,3,false)
would use the value in A1 to look through sheet2 (A1:A9999). If it doesn't find
a match, you'll get a #n/a back.
but if it there is a match, you'll get the 3 column over (C) returned.
Take a look at =vlookup() in excel's help for lots more info--or post back with
a more specific question. (I'm sure you'll get a better answer.)