I have an expense report form that I am looking to create a macro to make a new WS copying the formatted cells from WS named "master" and if possible, name the WS by date in cell O1

Right now, I manually copy "master" WS into new WS, then go to cell O1 and set it to ='April 7'!O1+7.....then I rename WS April 14 and so on......