In need of help with an idea

I have several worksheets whereby i can input data and another worksheet that acts as an index to all of the worksheets so i can click on a link within the index to take me to a particular worksheet. What i want to do is have a reference worksheet like a quick lookup that collates all the information on all the worksheets and also updates with any changes i make to any of the worksheets. All the links i have made are hyperlinks. Any ideas?

Hi,

There is a very good Excel functions workbook by Peter Noneley at http://www.rondebruin.nl/files/xlfdic01.zip

You find exactly what you are looking for.

HTH
Carim

Carim, I was looking at posts and came acroos your answer, you are correct the workbook is excellent, it has allot of content, great find
Thanks

Garf