I have 2 worksheets (in the same workbook). Both worksheets contain much of
the same information, however, some columns have been updated (changed from
unpaid to paid, add a check number, deposit date...) I would like to
consolidate this information without duplicating data. Is this possible?
See Example:

Sheet 1
Name Address Paid Check # Deposit Date
Bob 123 1st o

Sheet 2
Name Address Paid Check # Deposit Date
Bob 123 1st x 456 6/6/08