Excel VBA Help

I have built a very simple inventory and profit workbook to help with our little company store and I am trying to set it up so that each week is a new sheet. I need some VBA code that takes and copies the current sheet, clears Items on Hand and Items Sold columns, makes the new sheet name today's date, and then calculates the profits Year to date by adding the profit totals from each sheet up to this point. I pretty much wrote it I think, but was having some issues clearing the tables and repopulating the button to run the macro for some reason? Any help is much appreciated

The original format is xlsm, but TW won't allow macros nor will it allow the new file formats. My final format will be xlsm... As I know this will need macros