Hi NicNIc

This macro will make a link to every cell you in the range
Range("A1,D5:E5,Z10")
Change to the cells you want
Note: if you want to create many links from each sheet this is not the best option (max 256)

Alt-F11
InsertModule from the menubar
paste the sub in there from my site
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "Summary_All_Worksheets_With_Formulas" and press Run


You can also use the indirect function to create your formulas manual
Start here
http://www.cpearson.com/excel/indirect.htm



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


"NicNIc" wrote in message ...
The data in the worksheets have no formulas they are just typed information.
Does this make the process a little easier?

"Ron de Bruin" wrote:

Try this

http://www.rondebruin.nl/summary.htm

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


"NicNIc" wrote in message ...
I have several woksheets in a workbook that have differing data - Words
letter and numbers. I would like to create a summary sheet. I have worked out
how to get the data into the summary sheet. However the sheets have all been
renamed so i must insert every formula manually. Is there anyway for excel to
auto generate the formula for every sheet in the workbook?