Excel vba developer

Need vba code to copy value from differnet files on the the sharedrive and fill it into my template. In some casee there maybe if statement that i will need.

The code needs to be user friendly and can be easily modified by me..as the input in the template grows

Example of the template
Id# location id. Periodyrmonth value. Status