Automatically populating Log into Summary

Hello.

I have had a project put before me to create a data input sheet that will allow for a summary to be automatically populated on another worksheet.

I have created the Input sheet to be entered per column. The separate worksheet receives this information, via the copying process, and sorts it into rows of information. I have it setup this way specifically for the ease of use.

For example, my input sheet resembles the following:

Name..........................Jane Doe
School........................ABC Tech
Dates called in............05/13/09
....................................05/11/09
....................................05/09/09

The Summary sheet takes information from the Entry sheet and displays it like this:

Name.......................School....................# of times called
Jane Doe..................ABC Tech............................3


The problem is that I am trying to preset the formulas on the Summary sheet to copy and expect information from the Input sheet so it automatically populates info typed into the Input sheet onto the Summary sheet and that when I attempt to copy formulas to read from different columns into the different rows on the Summary sheet its creating a series of changing rows, ie. C11, C12, C13, etc, instead of C11, D11, E11, etc.

I have been unable to find a solution and to try and manually adjust each field manually for over 16000 cells is a bit... daunting to say the least.

Any ideas?

Thank you for your reply. I didn't realize I could attach the file, but I have now. I placed an example into the Input sheet and preset another two rows on the Summary page. Also, on the input sheet you'll notice it counts the dates, that is going to be a hidden row.

Thank you.

Sorry, I just got another request for the page. My manager would also like a populated page on the Summary worksheet that sorts by school, showing how many students of that school called and how many calls students at that school are making. It may just be that I have a horrific headache but I cannot even think of a way to do that in Excel. Access, sure, but Excel... I'm at a loss.

I've reattached an adjusted document with both worksheets. I've added two more examples and the area with sorting information. If you are able to think of a formula or macro I can use to preset this document I would appreciate it.

Thank you again.

Believe it or not I found a solution. I simply eliminated the Summary sheet, I found it to be unnecessary, and had the items I needed populated into a graph. Took a lot of playing around but I finally managed to succeed in getting it to work.

If you are curious I've uploaded the file.

Thanks again.