Macro to add sheet, name it based on previous sheet, and delete a range of cells

I have absolutely no experience in VBA code and cannot figure out how to record a macro to do what I need it to do.

I have a workbook that has sheet names "Day 1", “Day 2" etc. in which a person fills out each day of the job. In it there are daily costs for a list of vendors. This form is set up so that when a sheet is copied, it keeps a cumulative of cost associated with the vendor. I need some help writing code that will automatically copy the last sheet, rename the sheet Day (x), x being the last day in the workbook +1, and also fills (x) into the cell F15. Then deletes the cost in the Daily cost column (range F47:F76).

Please see attachment EXAMPLE.

Any help would be appreciated.