Exporting data from master file to pre-populate many excel files from a template

Thanks for the code Naveed works perfectly

I must admit I'm having a hard time understanding what the code is doing but i will play around with it and try adapt it to my actual situation but i think i can follow your logic.

Much appreciated!