Filter rows from 4 sheets based on column value

Hi there,   I'm having a bit of trouble navigating my way around some formulas trying to get this to work and after a few hours have decided to come here seeking help. I have an excel file with ...