Referencing using data in a cell?

[altitude2k]

I have a couple of problems. Firstly, is there a way to make the data i
a cell equal to the name of a worksheet. For example, if a worksheet (i
the case of the project in question) is called "43" how would I go abou
making a cell contain the number 43, or whatever the name of that shee
is. Not sure if this can be done, but its worth a try.

Secondly how can I refer to a cell on another sheet, but where the nam
of that sheet is kept in a cell. For example, in the same case again,
want data from a cell on sheet '42' cell 'AE6', so to make a cell i
the other sheet equal that, all I need to do is type ='42'!AE6 which i
easy enough. However, I want it to take the sheet name of '42' from th
value in a cell. So if the value in that cell is changed to '41' the
it will take data from sheet '41', cell 'AE6'.

Fairly complicated and I'm sorry if I'm not clear. It all comes down t
making things as automated as possible as people with less skill woul
be using this workbook. If I can help it, I would really like t
refrain from using VBA for simplicity and mainaintability reasons.

Thanks

 

[Frank Kabel]

Hi
#1: See:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

#2: Use INDIRECT. e.g.
=INDIRECT("'" & A1 & "'!AE6")