I'll try and keep this simple.
Sheet 1: Current 12 Months
In column B, I have a list of employee IDs. As this is an absence tracker, each separate occasion of absence for each employee is added as a new row (so the same employee could have multiple rows).
Sheet 2: Occasions Current 12...