Want to auto populate an excel sheet from a master sheet of data

In this attached example, this is a portion of a actual work procedure. The yellow highlited cells are the same work element within the master procedure but one is for one type of machine while the other is for same model but added options. This is a pattern throughout the entire worksheet. Basically 1 model with several different types of options. I don't want to have unnecassary elements in a work procedure.

So what I am trying to accomplish, and I have had some success but not enough to feel like I can accomplish this without some help, but anyway, I want to create a userform or dashboard which will allow selection of model #, model type #, then based off those selections have excel populate a worksheet with all correct procedures based off model type choice.

In this example there is 6 model variations, all share same basic procedure, but all have their own work procedure based on options, so my above approach will allow me to make changes to the master procedure only instead of changing 6 procedures.

I hope I made some sense, if not please allow me to try and explain again if needed.

Any help will be greatly appreciated.

Forum Worksheet.xlsx

Hope I can explain this way:

Master Sheet has multiple columns / headers labelled across the top like below

Company Contact Industry Sector Sales Stage Priority Country Competitor Held Account Comments


I have 25 other identical spreadsheets labelled by individual countries

I want to go to the master sheet, select a country from a dropdown menu, and then start filling in all the other columns on the master and have that information auto populate the individual country sheet with the same information. If I select Angola on master and enter all my data on the master, the Angola sheet auto populates and so on with each country I select on the master.

Thanks

Yes just realized that and apologies - new/first time user and all