Need a VBA code to save multiple sheets from a workbook to a sharedrive location

[Shravan5564]

Hi, I have an excel workbook where I need to save 4 worksheets among 8 and each one was named. These sheets need to be copied to a specific location with a new workbook. The sheet contains tables with data. the name of the new workbook should be of today's date. As we do this on a daily basis. Please requesting you to help me with this.

 

[Shravan5564]

Looking forward to a precise code from the geniuses.