Macro to Move Data Between Sheets Based on Columns

Hello all,

Need help writing a macro that will move data in one specific column and row to another sheet based on the header in row 1.

The columns that need to be moved are:

Library
Deal_Date
Title

At the end of sheet 1 (row 11 in this case), I need to move the data in sheet 2 into sheet 1, keeping the data across each row just as it is in sheet 2.

See sheet 1, then sheet 2, then after macro sheet in attached file:

I'd like to use the headers in row 1 as the unique identifiers for each column. The macro will need to identify the last row of data across all columns in sheet 1, then insert the data from sheet 2 in the corresponding columns, beginning with row 2 in sheet 2. Will need to loop through several thousand rows. Must keep data being moved from sheet 2 to sheet 1 in the same row.

Any help would be most appreciated - thank you!!

Question also posed at Mr. Excel: http://www.mrexcel.com/forum/showthread.php?t=531778