I have made daily sales report in excel with some of Macros, I am taking report using date filter. Now, I want to rename the sheet name automatically when I
click Email button, that name should be a date where I am entering in filter cell.

How can I make it? Thanks in advance.

Screenshot (1).png