Many ways to skin this cat

=Sheet1!C4
=Sheet1!C4
...

If the sheets will be always be accessible in an open workbook you could use
=INDIRECT("Sheet"&ROW()&"!C4")

In a macro you could use
For i = 1 To 100
Cells(i, 1).FormulaR1C1 = "=Sheet" & i & "!R4C3"
Next

Jerry

stardust wrote:

I have over 100 worksheets which are layout exactly the same. I want to
create a summary sheet to display only certain information from all of
them...like name, sales total, numbers of calls. I don't want to consolidate
or tally the information just display them. Does anyone know how to do this?