creating hyperlinks

hii..!!
it's quite difficult for me to explain my issue. I'll try my best...
here
Untitled.jpg

As u can see...i created hyperlinks in E2, E3, E4...
E2 refers to Cell A1 on sheet named 1
E3 refers to Cell A1 on sheet named 2
E4 refers to Cell A1 on sheet named 3

Since i have a total of 600 sheets, its not possible to create manual hyperlinks for each sheet. Is there any formula or VB command through which i can create hyperlinks keeping target cell absolute but sheet variable..?

they are numbered in sequential order but I have renamed the sheets with '1', '2', '3', '4'....and so on till '100'...

sorry for the confusion...i wanted to create hyperlinks for cells not the actual links.

Originally Posted by mcmahobt

If you are referring to retrieving the cell's contents, but simply through a formula format which you can drag down instead of manually referencing every sheet, try this in E2:

E2:  =IFERROR(INDIRECT("'"&ROWS($E$2:E2)&"'!A1"),"")

And drag down through row 101.

Hope this helps!

Thanks for trying and investing your time.
I got the values on the main sheet by trying ur code. This was my other question. So thanks in advance...)

Originally Posted by martindwilson

so you just want to link to each sheet a1 from the sheet names in a2 downwards
then e2 filled down is =HYPERLINK("#'"&A2&"'!a1","LINK TO SHEET "&A2 )
where
,"LINK TO SHEET "&A2 is the friendly name you want to use
and displays as LINK TO SHEET 1
if you leave it out it displays as
#'1'!a1

Wow...now that's exactly what i wanted. Thank you so much. U saved a hell lot of my time. Thanks again...