Hi all,

I'm not advanced in Excel by any means - apologies on the vague title.

In short, within this workbook, I have a sheet titled 'Worklist' - source of where the data for the attached tables is located. Every couple of weeks, I update the dates (A4, E4, I4 - etc) to ensure that they're aligned with what's in the Worklist sheet. With the formulas I've created for each respective team (example F7), I'd like Excel to look at the date in E4 and then in F7, populate data for the activities that have been completed in the Worklist for this specific day. Currently, I'm completing this manually for each team / each day which is a pain.

Appreciate your assistance with this

example.jpg