How do I know which sheets are to the RIGHT and LEFT to the Active Sheet?

Dear Forum,

I have a File which containts a lot of WorkBook and Moving to and Fro from in these WorkBooks becomes quite tedious and so thought of Making a Previous and Next Hyperlink in all the Sheets to go to the Next Sheet to the Right and the Previous to the Left of the Active Sheet in all Sheets and one common go Back to Index Hyperlink to take to the Index Sheet.

is there a better way of achieving this without manually doing it between 60-70 Sheets.

Please suggest some workarounds...

Thanks in advance.

Warm Regards
e4excel