Hi there I am trying to create a workbook that can monitor the progress of
students' results.

As of now I have managed to create worksheets using the "list" function.
Each worksheet is a list of the stundents in my class, a few other fields and
a column listing their percentage for a certain test.
Each worksheet has the data for the percentage scored for one particular
test. Thus each worksheet contains the grades of the same students but for
separate tests.

What I would like to know is how can I extract the results from each
worksheet for each student and place them in a separate worksheet such that I
can monitor the progress of each student.

For example, say I have a student Tom. In worksheet 1, his grade is 50%. In
worksheet 2, his grade is 65% and in worksheet 3, his grade is 71%. How do I
extract these individual grades from worksheets 1 to 3 and place them in one
row in a new worksheet? I hope that this can be an automated process such
that when I key in the results for the individual grades in worksheets one to
three for Tom, the are automatically filled in as well in the new worksheet.

I hope I am being clear in my description of my problem.