I am using Excel 2003 to design some registers for multiple college
activities with the front page a summary of students and each subsequent
pages is an activity's register. I would like to input the name of a student
into my first page and then a yes or no desicion based on what activity they
are doing. Based on that Y or N, I would like their name transferred to
relevant register on one of the following pages (this could very well work in
reverse but I don't know which is easier).

On the page the name is transferred to is a list of weeks in the columns
nest to the name with a total at the end. I would like this total transferred
back to the front summary sheet.