You could set this up a bit differently - rather than have one sheet per country, you could have a drop-down which allows you to select the country from a list, and then the display would immediately change to show only those records for that country.

You would still have to keep the Master sheet up-to-date, however, but the subsidiary sheet would always show the relevant data from the Master sheet.

Hope this helps.

Pete