Can I auto populate values in a coumn?


I have 10 sheets built in the same way: pre filled with many information. Each sheet will be used by many team members. But I need the team to be able to add rows in that sheet.

I have 4 columns that I would like to keep locked. What happens now is when a row is added the Complexity & Country column stay empty - which ruins reporting.

My question is: is there a way to make sure that each new row is auto populated with Country name & Complexity?

Thanks in advance!