Copy data from one workbook to other----Help

Write macro to copy data from Source File to assignment-2 file. Make sure you take care of following conditions
* Book with same name should not added to the destination, instead only its other fields should be updated
* Leave the Author column from source file; need not have to be copied.
* New book record found in the source file needs to be added at the last available row in Destination file.
* after copy of data, if I click on "Refresh Graph data buttons" then it should refresh data considering additional records.