Macro to create hyperlinks between sheets

Hi All,

I have a excel sheet where I have questions in the main sheet and answers by different candidates in other sheets of the same work book.

I need a macro where..
1) The sheet 1 should create hyperlinks to different responses for all answers given by candidates in different sheets.

Example:

i.e now in main sheet 1 if column A is with questions then col B should contain hyperlinks to responses of candidate 1 in sheet 2. (Since there are 20 questions i need 20 hyperlinks in col B to point to 20 answers of sheet two.)
similarly col C should hyperlink to responses of candidate 2 in sheet 3 and so on.

I hope its not confusing..

All i am looking forward for ,is the main sheet should contain all hyperlinks so that it references to the answers given by candidate.

Please help me out cause i need to work on more than 500 candidate responses. http://www.excelforum.com/images/smilies/eek.gif

Thank you

If you didn't figure this out still, can you upload the workbook. Will see if I can help.