Worksheets are Excel Objects. Objects can have custom Properties. Add to the top of each Country sheet's codepage:
Option Explicit
Property Get SheetType() As String
SheetType = "Country"
End Property
Any sheet can have any SheetType. Ie. "Products," "Prices," "etc." The Property code structure remains the same for all sheet types. Only the String changes.
Create a Country sheet Template, including any existing products in its List. include SheetType "Country" on its codepage.
Use a macro with an InputBox to get the new Country Name and copy the Country sheet Template.
Use a Macro to add the new Product info to all "Country" Sheets.
Dim Sht As Worksheet
For Each Sht in Sheets
If Sht.SheetType = "Country" Then
'Add your code to copy Product info to Sht here
End If
next
Good luck.
Au revoir.