The contacts form example here contains code to copy specific cell values to another sheet

http://www.excel-it.com/vba_examples.htm