Macro for creating separate files with fixed password from colum

Hi All,

I need urgent help for a macro which will create separate files from a column value

I have this data in the picture attached
http://static.ccm2.net/ccm.net/pictures/if1pma3Hps7YPUlRcTPE1EqT55I2RzepojcYCyIrcD0EJu8SQpNvaCBzCNtcju0Y-excel.png
Now the data is segregated to four day sheets named "5 to 9 days", "10 to 14 days", "15 to 29 days" and "30 days and above" as per the Column F (Days Remaining).
http://static.ccm2.net/ccm.net/pictures/dNWCETjgIgiA4ji9075Cm6XBU06HVQWzm1IBV54vgHva7YvJJI66hXtAraPbUAu1-excel2.png
The macro should create separate files as per the Country (Column E) for each of the day sheets separately.
Note: *The first four rows should be same for all the files.

• The file's name should be the Country code_Cash, for e.g. "USA_Cash"
• The pasword should be "abcd" for all the files.
• The files should be saved in 4 different folders named as "5 to 9 days", "10 to 14 days", "15 to 29 days" and "30 days and above" in the location where the master file exists.

Please get back for any details/clarifications.

Thanks in advance for your help.