Duplicate the sheet and updte the Master

[nsundarv]

Dear Friends,

Please help me in achieving this task

1. I have Country Master
2. I have Product Master
3. When ever New Country is added existing any one of the Country sheet should be duplicated and rename to the new country name
4. Then Product Master should be updated in New Country sheet
5. The same way when New Product is added that should updated in all the country sheet below the existing last item

Thanks,
Sundarvelan