Transfer data to a Report

Registration date
Friday April 11, 2014
Last seen
May 18, 2014
Hey Guys,

So my dilemma is I have (2) separate workbooks. Workbook (1) has A1 with all basic, address, phone #, etc. going down to A32. Column B is all the data I input. I have a macro set up so each time I'm done (its a call-in appointment sheet), the data is saved based off the individuals last name and it clears the cells for the next caller.

My problem...

I want to take that data and put it into a weekly report of all the calls received. I have in my report workbook Row 5 with all the same corresponding information I used in Column A on workbook (1) going horizontally. I want the information I input each time in workbook (1) to populate the report (not overwriting the info of course), but I can't seem to make it happen. Any help?