How do you reset an Excel Spreadsheet after Saving/Closing

Here's my latest quest from my friend who keeps asking for more stuff to be done to his work spreadsheet.

He wants a blank spreadsheet for the users to access each work shift.

However, the name of the spreadsheet file must be retained and not changed.

Basically here's how I've set it up:
His workers will input the info during their shift and close the spreadsheet when the shift is over, it automatically saves and emails him the spreadsheet.

He wants:
The next day when the worker arrives to be able to have a blank spreadsheet to access and enter the data into.

Is this even possible without creating a long list of excel files or should they just clear the data (won't be easy because the sheet is protected and only enterable fields are accessible)

Maybe there's a quick solution that I haven't thought of yet.

I'll stop here, I think I'm rambling on.
Thanks for any help.
Brian

I created a command button, thanks for the reply TMS.