Copying Data to a new workbook and save to a specific folder

Hi,

Is there a way to automate copying a specific data from an existing workbook and pasting it to a new workbook (Values and Formats). The filename of the new workbook is based on the criteria of the data that was pasted in the new workbook.

I have client list file with it's respective advisors. I would like to have separate the data per advisor. So if i have 10 advisors, I will have 10 workbooks as well. The filename should be the name of the advisor and the user can choose a folder where to save the file.

I hope the automation for this is possible.

thanks

Can anyone help please?

Anyone please