How do I convert text in one cell into a reference to a particular sheet and use that reference to get the data from a cell in that sheet? I am using OO 2.4.1 on Debian testing.
My use case: I have a spreadsheet with many data sheets (tabs), each with a date for the label - i,e, March 24 or April 3. I can reference a cell in a particular sheet in a formula by ='March24'.n89. What I want to do is create a new sheet, call it summary, that displays a set of cells in one of my data sheets. But I want to enter the name of the sheet in one cell in this summary sheet, and all the data in the cells on the summary sheet will now show the data for the sheet name I entered. For example, I have sheets summary, March 28, and April 1. In cell summary.a1 I put the text field March 28. The cell summary.b1 should now contain the data in March 28.a1. If I type April 1 as text in cell summary.a1, I want to see the data in April 1.a1 in summary.b1. How can I do this with a formula? Thanks! Mark
