VBA code for duplicating Excel Workbook

Hi all!

My company use delay logs where we record delays everyday for different customers.

At the moment every morning we're having to manually save new workbook everyday, which takes some time when there's around 30 accounts.

Is there a macro i can create that automatically generate a new workbook everyday with the days date?

My current file name is something like 'ESPN delays 12/02/2016' so i'd need the file name changing each day.

Thanks!