Link data from a report card to create a progress report with chart. HELP Excel 2007

Hi everyone. I'm "new" to excel--just realized it had so many more capabilities than what I used to use it for.

I'd like to do something like the following:
I have a report card with names in the column and scores as rows. I'd like to make another file/worksheet that would display a graph of the scores from the starting date (also a row near the top) to the ending date for each kid--so once I make a change such as changing the name of the student whose progress report I want to make on the progress worksheet, it finds the test scores and does the graphing/naming automatically in my new sheet.

Thanks.

I'm even having trouble with linking an entire row together (so I can move entire rows of data without accidentally changing just names but leaving scores unmoved).