Insert/append data from Sheet A to Sheet B

[evenings]

Hello all, I am wondering if I can copy data from one sheet and append to another in order to create an archive of data. Please see attachment.

In the Weekly Totals sheet I will keep track of daily sales of Tools. When the week is over and the sheet is full of sales data, I would like a macro to import the data according to Date and Tools to the Database sheet. Once the data is imported or copied to Database sheet, I will then begin a new week. This is where is gets tricky.

After starting a new week, I want the macro to know I began a new week and append to the Database sheet the new Weeks dates and values for each Tool. In theory after a few months of data values from Weekly Totals sheet I would be able to see all the Daily sales of Tools displayed in the Database sheet. Also, lets say I run the macro two times at the end of the week, I do not want the same information imported or copied over to the Database sheet. Would there be a way for it to identify say by date? If the same date has already been imported then do nothing else insert new information.

I am trying to avoid making a new sheet for each week. I think this works better. Thanks in advance.