It seems a lot of work; there is built-in functionality to take the effort out of this sort of thing. A pivot table for example (with or without slicer on the right).
If you really wanted to add columns for comments and the like you could have a short macro to copy the pivot table's values elsewhere.
2022-11-14_131545.png