Rename Sheets as per selection from Filters

Hello Experts,

I have a Macro File which creates a new sheet as per my selection and gets attached to Outlook to send email.
Suppose from drop down in D3 I select ABC as the customer name and from B5 I need to select the same customer name. Only ABC rows with header gets copied to a new worsheet which gets renamed as "Customer Details"
After selecting similar customer name from D3 and B5 - I'm ready to send email to my address list.

Now what I want is - If I select customer ABC (which gets copied to new sheet) this sheet should get renamed as per customer name. If ABC than the sheet name should be ABC getting attached to outlook email.

Everything is OK - Only the help needed is getting the sheets names as per customer name selection.

Many thanks for all your help

Regards,
Prakash

Hello,

I've attached a macro file.

For some privacy I have removed some of the coding from this macro file.

Hope this time it helps.

Many Thanks,
Prakash