How do I reference data from a sheet specified by text in a cell

[RedWolf]

I am trying to use the text generated in a certian cell as part of a function
which will reference the appropriate sheet and pull information from a
certian row.

[Anne Troy]

Use INDIRECT.
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"RedWolf" <RedWolf@discussions.microsoft.com> wrote in message
news:D58C016A-30A6-41FD-87A6-FD08910C7710@microsoft.com...
>I am trying to use the text generated in a certian cell as part of a
>function
> which will reference the appropriate sheet and pull information from a
> certian row.