Daily Report automation-split excel & send auto mail

hi, team here is the sample file

Step1: The base sheet has the report summary

Step 2: need to filter Column D (header Name:"ZSM")

Step 3: Save the file as today's report -" Column Name" which is "A" with the Date

If there are 150+, I want to separate all the ones into separate Excel sheets in a folder with the desired saving Names (A-Feb 22nd report)

after that

Step 4:

want to send mail individually by picking the saved report from the desired folders where I also want to add CC
(if required can add a CC list in the base)

Step 5: emails need to be sent through Outlook to individuals as desired

Pls help solve this automation problem