Row based excel file split

Hi,

I'm new to Macro and VBA. I'm looking a Macro or VBA regarding file split based on the row(s). The expected output should be

1. First Row or Row Header is a constant or common for each file.
2. Based on Cloumn A or B or C or anyother Column value, the file should be split along with the respective parellel data. Ex: If column A has
- Adam
- Brain
- Charlie
the output file name will be Adam then Brain then Charlie seperately with the data.
3. If my file has validation that also should reflect with the file which is split.
4. Macro or VBA should ask to the user to locate the path where the user wants to create the file. If the path is existed then the split file should create the same location.

Challenges
1. Everyday the Column A or B or C or etc will vary.
2. Everyday the validation will change..

Help me to Paste the Macro or VBA in my excel book with step by step procedure.

Note: Please excuse, I can't share the data though it is very sensitive. Hope the requirement is understandable. For further clarification do revert.

Thanks in advance.

Regards,
Vijay