I used Defined Tables feature (to define such Table, activate any single cell of general table, and from Insert menu, click on Table icon). With Defined Tables, you can use specific syntax to refer to various components (Table, Column, Header row, a cell in same row) of such Tables. The formulas itself are common Excel formulas. E.g. tData[RowNo] refers to column RowNo of Defined Table with name tData, tReport[[#Headers];[ID]] refers to header of column ID of Table tReport, and [@Owner] refers to cell in same row of Table where the formula origns from in column Owner. You can see/edit properties of single Table when you activate any cell of Table, and open the menu Table Design. And you can see and edit all Defined Tables from Name Manager of Formulas menu too.

I also used named ranges (nStartAge, nEndAge) - them you also can see and edit in Name Manager.

Defined Tables work generally like Dynamic Named Ranges we could use earlier, plus some additional features, like automatic expanding of formulas, formats, and validation rules whenever a new row is added to Table, and automatic correction of all formulas in workbook, whenever any Table Element is changed (e.g. you rename Table tReport as tAgeReport, and in all formulas the reference to tReport is automatically replaced with tAgeReport).

About Progress and Feedback - add columns for them into data Table, and enter them there! When you want to enter them on separate sheet, then the ID for them MUST be entered manually - otherwise you can't guarantee that this info remains linked with right ID.

And you don't need different reports for different age groups. You enter another StartAge and EndAge, and you get report for another age group on same sheet! In case you want to limit possible StartAge and EndAge pairings (Age Groups), add a sheet where you define such group (E.g with columns AgeGroup, StartAge and EndAge, instead current fields for StartAge and EndAge create a Data Validation List with AgeGroup column as source, and based on selected AgeGroup calculate Names nStartAge and nEndAge directly in Name Manager. User selects AgeGroup, and gets the report for this AgeGroup.