I'd like to create a numbers file with a cover sheet that pulls data from each subsequent sheet when it is added. So each numbered row represents a Sheet in the file. Each lettered column represents a standard value from the sheets. The sheets are all uniform (except the first) and as I copy a new sheet into the file it fills the details into the row. Am I crazy or is this possible?
Here is a standard example of how to gather data from multiple sheets, including new sheets as they are created. I'm not sure exactly what you need. Hopefully this example will get you started. If your sheet/table naming convention follows a pattern or is otherwise known ahead of time, you can pre-fill the sheet and table names and the data will fill in automatically when the new sheets/tables are created.
Formula in B2 =IFERROR(INDIRECT($A2&"::"&B$1),"")
Fill down and across to complete the table
I summed the results in the footer row at the bottom but that's not a necessary step.
My example document has Sheets 1-5. As I add new sheets their data will fill in automatically.
Here is a standard example of how to gather data from multiple sheets, including new sheets as they are created. I'm not sure exactly what you need. Hopefully this example will get you started. If your sheet/table naming convention follows a pattern or is otherwise known ahead of time, you can pre-fill the sheet and table names and the data will fill in automatically when the new sheets/tables are created.
Formula in B2 =IFERROR(INDIRECT($A2&"::"&B$1),"")
Fill down and across to complete the table
I summed the results in the footer row at the bottom but that's not a necessary step.
My example document has Sheets 1-5. As I add new sheets their data will fill in automatically.
Thanks very much. It's good enough to get me started.
Creating a Numbers file
