I would like to have sheets named after a certain text string in a cell and
refernce them in formulas

For example:

I have a sheet named '123Main' and a sheet named 'Main'
On the 'Main Sheet' column 'B' is labelled 'Address'
Cell B5 has text data '123Main'
I want to be able to reference from Main!C5 a formula as such:

="whatever text is in cell Main!B5 is the sheetname to reference a cell on
that sheet"

I hope it is clear what I'm trying to do.......thanks.
--

StompS
Portland, OR
http://www.geocities.com/pdxinvestr/Stomps.html