Automatically dating individual sheets within an Excel workbook

I have a daily spreadsheet set up for each day of the month. There are 31 sheets in this workbook. A new workbook is downloaded from a master copy every month. I am trying to set it up so that you ca...