Hi Titam

If there are a few sheets you can create the links yourself
=Sheet2!A1

You can also use this macro to do it
http://www.rondebruin.nl/summary.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Titam" wrote in message ...
I have a text data stored in same cell of different worksheets on the same
file. I need to list them down in a single fresh worksheet. Is there any
formula or any way that I may use?