This will work *if* your sheets are using the XL default names (Sheet1,
Sheet2 ... etc.).

Assume you're polling B1 from each sheet:

=INDIRECT("Sheet"&COLUMNS($A:A)&"!B1")

And copy across as many columns as you have sheets.

This creates links to each sheet, where the "Main" sheet will display the
real time values in B1.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"prem" wrote in message
...
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.