Creating Single or Multiple Workbooks From Specified Data in Excel

Hi

I would like to ask for your assistance and expertise in providing me a macro to solve the following.

I have an excel containing multiple accounts on it and I would like to create a button that when I click it, it will create new workbook or workbooks separating each account name Appraisal, Bankruptcy, Litigation etc. Meaning from an excel containing all the account name, it will produce a new workbook containing only the Appraisal, and another workbook for Bankruptcy etc. If the excel contains only Appraisal, then only one workbook will be created. The width for each column should always be fit. Then from there, I will be the one to save it to CSV.

Attached is an example of the file for your reference.

Hoping to hear from you.

Thanks,
Marlon