I would like to know how to make a button to copy the sheet with empty cells but existing

Hi,

I have a cash up sheet for my business that we enter figures into.

I'd like to know if it's possible to create a button (or some other way) to copy the sheet to a new workbook with the existing formulas but empty cells.

I hope that makes sense, It would save me a lot of time from having to clear all the cells and save as another new workbook.

Thanks for any help.

Duncan.

Thanks for that but I can't get it to work.

It just seems to copy the one end sheet (one of 8 sheets) but doesn't clear the contents.

Any ideas?

Thanks