update daily sheet
 

I currently use a worksheet for my type of business (engineering) that I need
to place a key to update each day. I do a daily report that calculates
volumes, and daily and cummulative costs as well as a few other things. I
would like to be able to simply update (select a key) and it create a new
worksheet (not eliminating the old) with the next days report number, date,
and update the inventories (I now have to reate a copy of and rename and
manually update it) and cummulative costs. I know it is possible as I used
to know how to do this many years ago. I am now using Excel 2007.