Hi, I know how to link worksheets basically. My problem is interesting though.
I have to do this in Excel....I can't use Access.

I 3 worksheets that have people's names and groups of classes they took.
Each worksheet has a different group of classes.

I would like to know if I can have a Main worksheet that has all 3 sheets
worth but when it flows into it the person's name only appears once.

Each core worksheet may look like this.

Name Class A Class AA Class AAA

the next sheet would be

Name Class B Class BB Class BBB

and so on for the 3rd sheet.

Can I have that 4th sheet that compiles the other 3?

Name Class A Class AA Class AAA Class B Class BB .....and so on?
Is this possible without having that persons name come up 3 times?
Thanks in advance!