Cannot bring up a new "fresh" sheet

[kwik98]

I have a workbook with several sheets. The first sheet is a form with dropdowns, data validation and formulas in it that is used to populate the second sheet. This data changes everyday. I have macros that perform functions that I need running from a macro button on Sheet1.The information on it is compiled (added to) the second sheet (thru macros)and the workbook is copied and saved to the same location everytime (overwritten). My problem is when I open the workbook each day to enter data into Sheet1, it still has the data from the previous day on it. I need a "fresh" sheet with formulas, macros ect...to enter the data on ....perform the macros and continue the process over and over. In other words I need to overwrite the workbook each time I save it ( to keep compiling all of the info on Sheet2) EXCEPT for Sheet1. I need Sheet1 to be a fresh sheet every time I open the workbook. Any ideas on this?
Have added Sheet1 as the example. Thanks