Scenario:
The original workbook contains 2 sheets "Summary" and "Template".
When a user wants to collect data (about a child), they copy the template sheet (right mouse click/copy/move to end of same workbook). They rename the sheet with the Childs Name. They then populate the sheet with the data being collected. The name of child cell in the new sheet is populated when the sheet tab is renamed.
Its the Summary sheet I need help with please.
* I would like the Childs name from each sheet to populate on the Summary eg Child 1 in A2, Child 2 in A3 etc (doesn't have to be in the A column if hidden helper columns are required)
* I would like the child's date of birth, mothers name and other data to populate in columns in the Summary sheet.
Because the sheets will be copied & added in an ad hoc manner, as and when needed, I'm unsure which function to use and how the Summary sheet will update each time a new sheet is added.
We're expecting up to 50 sheets per calendar year = 1 workbook.
The users are inexperienced Excel users so looking for an easy way to populate the Summary sheet, hopefully without the need for a macro and hopefully so they don't keep coming back to me when they add additional sheets and the Summary is not updating
Open to any options or your thoughts.
Thanks
Bookmarks