Calculate _worksheet_ for soruce data?

[sdm]

I want to get text data from a different worksheet depending on the value I
put in the formula. Can I name worksheets using numbers (1,2,3,...) and use
changing values in formulas to refer to the different worksheet?

e.g.: On my summary worksheet, different cells should get data from
1st cell = a value in a cell in worksheet 1
2nd cell = a value in a cell in worksheet 2
etc.

 

[Shane Devenshire]

Hi,

Yes, but you don't need to name them with number. In any case use INDIRECT.

And if you use a value in the formula (the sheet name is still text) so you
will need to convert the sheet name to a number in the formula (could use
VALUE) or you need to convert the number to text using TEXT.