Create workbook from cell name and list

[brais]

Hi people, Ive been searching for many places but I dont found any information about what I want, I have excel 2016, and what i want to do is this.

lets suposse i have a list of values from C1 to C10, I want to put the first value of that list in A1 and save the excel with the name of the cell A1, then put the second value of the list on A1 and save the excel with that value as name, how can I do it?

Thanks for the help.

[brais]

I want to generate that files automatically because I have a form that changes when you put in A1 the different values of the list of C1:C10.

Thank you.

[millz]

I have a form that changes when you put in A1 the different values of the list of C1:C10.

I don't think anyone understands what you meant, even your explanation in your first post is confusing. Attach a sample workbook or the piece of code you have.