Put this formula in A1 and copy down for your number of sheets........

="=Sheet"&ROW(A1)+1&"!$C$70"

Then, run this little macro........

Sub TextToFormula()
Range("A:A").Value = Range("A:A").Value
End Sub


Vaya con Dios,
Chuck, CABGx3



"deidre" wrote:

I am trying to create a list (like summary) of all the comments from a
survey. The comment are all in the same cell (i.e. C70), but on approximatley
140 worksheets.
I would like them all to be listed wihtin my 'summary' worksheet... but
can't figure out how to 'compile' them. Help please.