Why not add one forms button on the sheet and assign this macro

Sub test()
On Error Resume Next
Sheets(Cells(ActiveCell.Row, "A").Value).Select
On Error GoTo 0
End Sub

It will go to the sheet name in column A of the activecell row


--
Regards Ron de Bruin
http://www.rondebruin.nl


"neilgrant" wrote in message ...

Thanks Ron !!
I tried the second solution you suggested and it works great.
I would also like to make the sheet names on the summary sheet into
hyperlinks to jump to the detail sheet, would you have an example of
the code that I can add to do this?

thanks
Neil


--
neilgrant
Posted from - http://www.officehelp.in