I omitted the trailing quote. You don't need to substitute the cell value,
Excel will do that, so use

=INDIRECT("'"&A2&"'!A1")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in message
news:B1F5CC4F-7258-488D-9304-7048C6BA70B9@microsoft.com...
> Chip,
>
> Thanks. I followed this exactly - I think but it still tells me I have an
> error. The particular worksheet I tried it on is labelled - Accel_Lifts -
> and so I got:
>
> =INDIRECT("'"&Accel_Lifts&"'"!A1)
>
> But it comes up as a syntax error!
>
> Paul
>
> "Chip Pearson" wrote:
>
> > Paul,
> >
> > The syntax is
> >
> > =INDIRECT(double-quote single-quote double-quote & A2 &
> > double-quote single-quote double-quote ! A1 )
> >
> >
> >
> >
> >
> > "Paul Condron" <PaulCondron@discussions.microsoft.com> wrote in
> > message
> > news:887D6FF3-D552-4942-A551-0F99A11730F1@microsoft.com...
> > > 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.
> > >>
> > >>
> > >>
> >
> >
> >