Sharing Data Between Sheets

I am new to this forum, but I need help every now and then and I thought this might be the place to go! I am creating a workbook of information for a school sporting event. We have a ton of participants. I want to add their information to the main sheet with their contact information and what not. Then I would like to take the list of student names and add them to other worksheets in order to create a weekly log where we record their times for each practice that will be printed out weekly to hand write the data on the field, and other worksheets for each month where their stats are recorded, and a worksheet that summarizes everything. The problem that I have is that new people keep popping up and we need to add people. There are a few of us doing this and not everyone is consistent in entering the data in all areas. I was hoping that when one person is added to the student info page, their name would then automatically be added to all of the other sheets with names listed on them. That way we are sure that everyone is accounted for. I know there has to be a way to do that...any answers?

A fairly simple way would be to just reference the Sheet1 column containing the names in each of the subsequent sheets.

eg

Imagine Sheet1 has 3 people in cells A1 to A3
Alan
Frank
Mary

In sheet2, cell A1 you would have the formula: =Sheet1!A1
and copy this formula down to say A100 (or A64000 if you're feeling generous)

this will therefore show the list of names in Sheet2 that are in Sheet1.

Thats at its most basic, as you'll see if there isnt anything in the cell of Sheet1 then it puts a zero in the Sheet2 cell so to get around that make your formula =IF(ISTEXT(Sheet1!A1),Sheet1!A1,"") so it only displays something if theres TEXT in the cell.

theres many other solutions but thats probably the easiest one to use.