Hello BEAR833,

I think you will need indirect referencing, a tricky way browsing through your sheets. I can not tell you if there is a more easy way, below is my tip.

First you need a list of your worksheets. For that, I wrote a simple Visual Basic macro (assume you are familiar with "how to run macros"). This will use the current sheet and will list all the sheet names one below the other. The list will appear starting from the top left cell in current sheet. Try it if you like the idea.
Alternatively, you can simply type in the worksheet names in a list.

Sub SheetNames()
For i = 1 To Worksheets.Count
ActiveSheet.Cells(i, 1).Value = Worksheets(i).Name
Next i
End Sub

And the result will be something like this, depending on your actual sheet names:
Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
etc.

Then, you can use referecing excel formula to take the content of the needed cell: e.g.
- Assume your cell to refer to in each sheet is "B12".
- Assume that A1 contains the name of a worksheet.
Enter this formula next to the sheet names above, and you can copy it down simply. "A1" in the formula shall change as you paste downwards.
=INDIRECT(A1&"!B12")

And it will result the content of cell "B12" in sheet named in cell A1
Good luck! Tell me if it worked.

ps. The macro simply overwrites the cell contents in the active sheet. Prevent problems from unintended macro runs, so please run it only if required. Also I suggest to delete the macro from the file which you might pass on to someone.

regards,
Tony

Please give me the formula of excel worksheet the student who get 35 or miore marks in each subject who pass, and less then 35 fail

To copy the formula without changing cell referrence.... we have one way.

ex: in cell 'a1' we have a formula as 'c1+d1' and if we copy the cell/formula to a10 then the formula will be copied as 'c10+d10'.

if you dont want like this, then change formula in cell 'a1' as " $c$1+$d$1".

Write this formula in Cell B , C and any one else but not in Column A ..... Column A contains the values

A
1
2
3
4
6

and in Column B write this formula and drag it down
=INDIRECT("Sheet"&A1&"!"&"B12")

you will get the result

=Sheet1!B12
=Sheet2!B12

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

The INDIRECT function works perfectly, except for one minor detail of the formula. As you stated in your example:

Write this formula in Cell B , C and any one else but not in Column A ..... Column A contains the values

A
1
2
3
4
6

and in Column B write this formula and drag it down
=INDIRECT("Sheet"&A1&"!"&"B12")

you will get the result

=Sheet1!B12
=Sheet2!B12

The only problem with it is that Excel needs the apostrophe (') when referenceing sheet names. so to actually get the value from the different sheets, you will need to add an apostrophe before referencing the sheet and also just before the "!"

The forumula would then be: =INDIRECT("'"&A1&"'!B12") where A1 is the worksheet name that you would like to grab the number from and B12 is the cell on that worksheet that you want to pull. Also note the "'" is actually quotes-apostrophe-quotes and there is also an added apostrophe before the !.