Creating standard reports from a excel data workbook

Hello,


I hve a requirement there is a standard template(Master1.xlsx) with fixed rows and columns. I need to create the reports for some 100 to 200 managers form a data file(Master2.xlsx) in the format of standard template(Master1.xlsx).
I have created a macro whcih is working fine. but i feel this can be tuned up a bit more by using standard vba. Can someone pls help me with this.


If you see Master2.xlsx you will see there are 3 worksheets so i want to create a report for each of this worksheet. The report has a standard foramt whcih is Master1 workbook.

My criteria to create a report is if N size is >4 whcih is found in the cell "d3" of Master2.xlsx. create it otherwise move to the other worksheet.

I have attached my sample files and the macro i have created.

THANK YOU!!