Mirroring Rows

[Humanist]

Hi. I use Excel to track every aspect of my classroom. I have been teaching myself from helpfiles and have mastered many new commands, but am stumped by something that should be easy. I currently have everything on one worksheet, but wish to add more sheets that will deal with the same rows (students) but will contain different data in some (but not all of) the columns. The problem is this:
I can see how to have Sheet2 update from Sheet1 normally
I cannot see how to have Sheet2 update from Sheet1 when I insert rows in the middle of my data so that I can insert new students into their classes.

Can I have Sheet2, 3 etc all manage rows based on Sheet 1 even with inserts?

Thank you!
Josh

Edit: I am sorry - I should have posted this to new users. I am sure this is too easy for this area.

[ChemistB]

If you have the same template on all the sheets.....
hold down the control key while clicking on each tab in which you wish to add rows. This groups the sheets.
Then insert the row on the active sheet. The row will be inserted on all sheets. Anything you type on the active sheet will appear on the other sheets also so be careful.
To ungroup the sheets (don't forget to do this), right click on a tab and choose "ungroup sheets." Is that what you were looking for?

[Humanist]

Thank you.

I just gave this a try: it works very well! I initially had a problem when I wantd to paste a student from an old course into a new course, but that was only because my sheets weren't identical, which they now are!

Thanks!