Hi All,

I'm new here and do have a little bit of experience with excel but not as much as some you guys, well most of you!

I am looking in making/designing a sheet were technicians can input data onto a spreadsheet for various data. E.g. Techs name, date, equipment, temp, humidity, water levels etc.

My problem is I can't have 52 sheets per year (weekly) so I was wondering if I can have the input sheet running all the time but the data is being saved in a different book or sheet. So bsically every week the tech can just hit a reset button to clear all of the last weeks info and enter the new info and nothing will get lost but just stored elswhere?

I know it's alot but I believe with some help and loads of sweat and tears this is possible, maybe not? What does the pro's think?

Thank you for any help in advance!

Woutie out.