extract data from various excel files on common field using vba

Please give me the code to prepare a consolidated report with the Titles of the books of all members as well as a report on individual Member with the Titles of the books.
The Member ID & Member's Name are in one excel file.
Book ID and Titles of books are in another Excel file.
Member ID, Date, Book ID of books either Given by the Friends Circulation Library or returned to the Library and in the last column G for Given and R for Returned are stored in another Excel file.
Thanks in advance.
Cross posted [url=http://stackoverflow.com/questions/19442818/summary-to-be-generated-from-multiple-excel-files-using-vlookup-in-vba]here[/url].
This is SOLVED.