Bob,

Many thanks but I can't get this to work. I have played around with the " '
and ( ) but I can't seem to get the logic right. I also tried to insert a ,
before A1 but that didn't seem to help either. I'm probably doing something
stupid!
Regards
Paul

"Bob Phillips" wrote:

> =INDIRECT("'"&A2&"'!A1)
>
> where A2 holds the sheet name
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in message
> news:374FB5AC-5BA2-4BE4-A999-4CC875481941@microsoft.com...
> > I have a 'Master' worksheet containing a list of the other worksheets in
> this
> > workbook. The list will be added to regularly. I want to create a macro
> that
> > when run will take the worksheet name that is highlighted in the 'master'
> > list and GoTo cell A1 on the related 'Detail' sheet.
> > Any help would be much appreciated.
>
>
>