Go to Quick Filter options. Apply to Worksheet and then select All using this data source.
thanks for your answer. Am afraid i probably left out an important part.
Whilst I want to update all sheets - on some sheets I have it at a country level only, not just cities.
So "all using this data source" is true for 75% of the information - is there an alternative way?