I need ideas on how to best compile information in a workbook

Hello,

I am building a workbook to help me at work with scheduling NPO groups for volunteer opportunities. The bulk of the book shows me what groups have already been booked in for a shift in that date/location. I am trying to build additional sheets per group that consolidates information on that sheet but I am a bit lost on getting it working. Of course I can do it by hand but if I can automate it, even better.

For example. Each time JUMA is listed in column E8:E38 It would copy the date from B2 (Hidden) to column A in the sheet that is called "JUMA", then I would want it keep working down the same column A but list the date in E2 for each JUMA in J8:J38 and so on for the entire workbook. The idea to consolidate the information for each group into its own sheet.

All advise would be great