"That is, could it be made so that an entry on sheet one would automatically be reflected in the data on say sheet 23?"
Create the spreadsheet. In Numbers, sheets are called Tables. Create the tables you want, I only created 2 to test this.
On the second sheet, select a cell and in the formula line, put an = sign. Go to the first sheet and click the cell that you want to take the data from. Accept the formula in sheet 2.
Now anything entered into that cell on sheet one, will also appear in the cell you chose on sheet 2.
Is that what you are trying to do??
Forgive me if this has been asked and answered before, but given that the search function here is utterly useless, I'm hoping somebody won't mind helping me out.
I have a donor list from which I wish to extract individual statements. For a other reasons, it exists now as an Excel spreadsheet, which I have read into Numbers ('08 version), and I can't figure out how to take single lines of data and make those individual statements, save one by one, by hand, cut and paste.
I could do a mail merge in Appleworks, if I had the data in an Appleworks database, although constructing that database would be a major pain. Is there any way to create separate sheets and have the data function relative to the main sheet? That is, could it be made so that an entry on sheet one would automatically be reflected in the data on say sheet 23?