Hi Sir / Madam,
Let me help you. I know how to complete this job. I can drive Excel, lot's of experience using Excel as a tool to present, to manage, to summary, etc.
For this case, my understanding as what I have done, step to do this job is by setup a dynamic data (source) and create a static report which read from dynamic data. For this case I will use array formula.
Hopefully, I can work with you.
Best regards,
Poltak