try something like

for each ws in worksheets
dlr=sheets("summary").cells(rows.count,"a").end(xl up).row+1
sheets("summary").cells(dlr,"a").value=ws.range("c 70")
next ws

--
Don Guillett
SalesAid Software

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