Convert cell data into a worksheet name via a formula

Hello -

I have a summary page that is pulling totals data from many worksheets. I
have the worksheet name [in this case a number] in column C on the summary
sheet .

I would like to be able to a build a simple formula that uses the data in
Column C and converts it into the worksheet name so I don't have to key in
the formula manually for each row.

In this example, the worksheet name is "1" and that name/number is located
at c11

='1'!G3

thanks!
Sandy

=indirect("'" & c11 & "'!G3")

--
Regards,
Tom Ogilvy

"Sandy" <[email protected]> wrote in message
news:[email protected]...
> Hello -
>
> I have a summary page that is pulling totals data from many worksheets. I
> have the worksheet name [in this case a number] in column C on the summary
> sheet .
>
> I would like to be able to a build a simple formula that uses the data in
> Column C and converts it into the worksheet name so I don't have to key in
> the formula manually for each row.
>
> In this example, the worksheet name is "1" and that name/number is located
> at c11
>
> ='1'!G3
>
> thanks!
> Sandy

Thanks so much, Tom ;-))))

"Tom Ogilvy" wrote:

> =indirect("'" & c11 & "'!G3")
>
> --
> Regards,
> Tom Ogilvy
>
> "Sandy" <[email protected]> wrote in message
> news:[email protected]...
> > Hello -
> >
> > I have a summary page that is pulling totals data from many worksheets. I
> > have the worksheet name [in this case a number] in column C on the summary
> > sheet .
> >
> > I would like to be able to a build a simple formula that uses the data in
> > Column C and converts it into the worksheet name so I don't have to key in
> > the formula manually for each row.
> >
> > In this example, the worksheet name is "1" and that name/number is located
> > at c11
> >
> > ='1'!G3
> >
> > thanks!
> > Sandy
>
>
>