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

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.

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

Use INDIRECT.
http://www.officearticles.com/excel/...ft_excel.h tm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"RedWolf" wrote in message
...
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.