Save same format file with different customer names and same customer name in Cell A1

[praveenlal]

I have a list of 40 customers. I want to save same format excel files for all 40 customers with File Name as customer name and Cell A1 should contain same customer name as file name. Is there a way to automate this ?