Smart stakeholder register and auto-updating meeting attendance tracker sheets for managing 700+ people

I need a smart, excel based register to track people, their details, which meetings they've been allocated, and their attendance. I have a master list/sheet with approx 700 people in column A, with approx 5 columns of details, then approx 50 different meeting group columns. I have used x to allocate people into each meeting group. Now I want to automatically create a separate attendance list for each meeting group on separate sheets within the same excel workbook. Each group will meet 10-12 times each and I want to track each meeting attendance by date on the same sheet. I want these attendance lists to update when I add new people and x to the master sheet, however I don't want the names of people removed from the attendance sheet if I delete an x on the master sheet. I also want an index page of tab names with a go to index button at the top of each attendance sheet.