Adjusting Reference Cells Within Workbook

[MysticMint]

I have a workbook where I have several summary worksheets; each worksheet records the progress of several students on an achievement (i.e., "Complete", "Partial" as each student achieves the goal). The students are organized in columns - student 1 is tracked in column A, student 2 is tracked in column B, etc. I also want to have separate worksheets, one for each student, that I would like to be able to print out for parents to show how their individual student is progressing. I have created one individual student worksheet template that connects back to the appropriate cells in the summary worksheets as needed (i.e., my separate worksheet form has "=Sheet1!A1" to refer back to cell A1 in the Sheet1 summary worksheet, "=Sheet2!A2" to refer back to cell A2 in Sheet 2 summary worksheet, etc.). These aren't "links" - they are just a reference with an = sign to summary worksheets within the same workbook. I would like to copy this separate worksheet form multiple times in the same workbook, so that I have 10 separate worksheets for students 1-10. I would like the connections in the separate worksheets to update automatically so that the connections for student 1 refer to cell A1 on Sheet1, the connections for student 2 refer to cell B1 on Sheet1, etc. Is there a way to do this automatically? Otherwise I have to go in and adjust all these references manually in each individual student worksheet, which is tedious. I am not an Excel power user so am not too familiar with VBA, etc. Thanks.