help creating form to save data into new sheets

[digitalkryme]

Hi all,

First off, bear with me, im not totally new to excel but what i want to achieve seems way beyond my current knowledge and im not sure where to start.

Im currently running a pub and as part of that at the end of the day i do a simple spreadsheet that shows the takings for the day, any expenses and if the till was up or down.
This is fine and seems to work ok, i simply have it as a template that i open each day and save with a different file name each time (the date basically)

I then decided to get clever and add a 2nd sheet that would also record my wastage for the day, again this worked well initially as it was a seperate sheet and i was very proud of myself having conditional colour formatting and calculated totals for the week.

Then i ran into a problem, because i was using a template again, but i wanted to keep updating the same file for a week, then have a new template.
I also combined the two sheets into 1 book thinking this would be easier, but instead i've made it considerably more work and confusing for the staff.

What i would like to have is the same 2 sheets, but with the date from the first sheet being saved onto a 3rd sheet that would simply keep track of the date and the takings, expenses and difference in the till, so that this data would always be there for reference and book keeping.
then basically the same with the wastage.
So effectively i would want a form to fill in each day with the takings, expenses and difference in the till (maybe who worked what hours as well) and then fill in the wastage for each product, and have it save into a seperate data sheets.

Im not sure as i have explained that too well, but hopefully someone might have a clue what im on about and be able to give me a little pointer as to where to start.

I have attached the sheet as i have it at the moment, so you can get a better idea what my ramblings mean.

Thanks for any assistance

Tony