Formula to pull information from one column to another based on value in a third column.

Please see attached excel spreadsheet for example.

In the 'Names' tab there is a list of Names, files, and locations.
In the 'Locations' tab I would like to sort the information from the 'Names' tab by location.

For example; On the Locations tab, in line 2 I would like 'Ember' to appear automatically under the England and France columns and the Files column next to each of those should also pull the value from the corresponding Files column.

I believe it should be something like...
Y2: ...if text in column C or D = England then show text from column A
and
Z2: ...if text in column C or D = England then show text from Column B

Thank you for your help,