Create multiple files based on one column of master sheet in Excel and copy paste information, Do the same for other tabs

Title does gives me suggestion for the questions which already might have an answer but they, Don't i have tried some modification to the code but they do not seem to agree. Here is my problem. I have a master sheet with three different tabs. All have information of 50 countries divided among different rows. Column a for every tabs have country names only ( 50 countries only) Number of rows attached with each country do differ. Is there any way to create multiple files based on the country list and create identical tabs in each excel file while copying the information from the master sheets and its respective tabs.

Recent Questions...