Worksheen name referencing to create a 'back' button hyperlink

[Paul Adams]

Hi, I'm trying to use Excel as Internet looking database to look after various suppliers we use. it uses lots of worksheets with hiperlinks all over the place that takes you to other areas of the workbook you want to go to. I've got over 60 worksheets that produce various graphs on each one but all automatically generated from one pile of source information worksheet so no trouble to update. All thats different on each worksheet is the name of the supplier at the top and then all the rest sorts itself out, its working really well and I have 5 macros on each worksheet which use the name at the top on each to then go away and generate various reports on a seperate worksheet, so all I have to do is copy a macro button onto each worksheet and it works fine for the new worksheet when I copy it across.

What I'd like though is when the macro generates the report, for it to also add a hiperlink back to the worksheet you were looking at. I can't use the name of the supplier at the top as its not identical to the name of the worksheet due to excels limitations as to what you can type in the tabs.
Is there and way when writing a macro I can get it to refrence the name in the worksheet tab I'm currently on and then creating a hiperlink, later on I can then use it to write the hiperlink in the macro after the report is generated to jump back to the supplier worksheet you were on. all I have to do is copy that script into the other four macros and then for all of the 60 plus tabs, will give you the option of a 'back' button whatever one you are on

hope I made some sence and someone can help.....

[Paul Adams]

Nobody can help?