An auto filter doesn't work due to the structure of the spreadsheet. If I filter this small section of data I can't put filters in place to filter the main bulk of data further down.

I would also like the update to be automatic. A lot of people will use this sheet and I'm sure some of them will forget to manually refresh an autofilter giving them incorret data.