dynamic worksheet reference

Ok I have a situation where I would like to call a specific worksheet using a reference to another cell as the worksheet name.

In the case that I am working on I have invoices that I am calling into a summary of invoices. The worksheets are named after the invoice number. The invoice number is also listed in the summary. So, I would like to simply plug in the invoice number (same as worksheet name) and the rest of the information from that worksheet will automatically be completed.


Can someone please help me with the formula?
right now it looks like this:
[='InvoiceNumber'!$A$1]
it needs to look something like:
[='(call to invoiceNumber column for worksheet name)'!$A$1]


thanks.
Brett

Try using INDIRECT, such as

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

--
HTH

Bob Phillips

"bmccall17" <[email protected]> wrote in
message news:[email protected]...
>
> Ok I have a situation where I would like to call a specific worksheet
> using a reference to another cell as the worksheet name.
>
> In the case that I am working on I have invoices that I am calling into
> a summary of invoices. The worksheets are named after the invoice
> number. The invoice number is also listed in the summary. So, I would
> like to simply plug in the invoice number (same as worksheet name) and
> the rest of the information from that worksheet will automatically be
> completed.
>
>
> Can someone please help me with the formula?
> right now it looks like this:
> [='InvoiceNumber'!$A$1]
> it needs to look something like:
> [='(call to invoiceNumber column for worksheet name)'!$A$1]
>
>
> thanks.
> Brett
>
>
> --
> bmccall17
> ------------------------------------------------------------------------
> bmccall17's Profile:
http://www.excelforum.com/member.php...o&userid=27371
> View this thread: http://www.excelforum.com/showthread...hreadid=468869
>