Bob,
thanks again but I obviously haven't explained my problem correctly and what
you sent me won't work. I'll try again because this is really getting to me
(and hope you still have the patience to reply!!)!!

On Worksheet 1 - my 'Master' or 'Front-end' WS, I have a listing of the
companies whose details will be shown on other Worksheets within this
Workbook. This list has 4 columns and I want one specific one of these to be
a link to its associated Worksheet so that when I reference this cell in a
GoTo macro, it will go to cell A1 of that particular Worksheet. I'm assuming
that if the macro is created as 'relative' that it will take me to the sheet
that relates to the list entry being highlighted on the 'Master' WS.
The list on the Master WS will be expanded as time goes on and so this
automatic link to the associated detail sheet is a key part to making it work.
Once again, my thanks for any help I get.
Paul

"Bob Phillips" wrote:

> 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.
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
>
>
>