Complex If Functions

I am working with 2 spreadsheets and want to link them. I had them linked and working, the problem is when I add a new row to the 1st spreadsheet with all of the formula's that I have in the 2nd spreadsheet.

Generally here is the problem:

I have a list of names in Column A
In Columns C through AM There is data entered
I have a spearate worksheet for every month (Jan - Dec)


I want to transfer this data into a summary page for each person listed for each month (not on separate tabs but on one page showing what each person took per day each month) I have attached a copy of the summary Page with the formula I was using.

How can I create a fomula that will find the person's name and enter their data into the coresponding day's cell?

Sorry I haven't got XL here, but wouldn't a Pivot Table be what you need?
Cheers