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.
--
sdm