Dynamic filter across sheets

Hi all, Fairly new to excel and I am trying to piece together a stat collation spreadsheet which works in conjunction with office forms. However, due to how the form has been set up, my locations ar...