meeting agenda, using various filters

i actually created it using a lot of IF/AND/OR's and a basic macro - not so familiar with proper filtering / pivots anymore.
however, i know there are much better / lean ways to solve, any idea welcome

attached the file with dummy entries.