I have a spreadsheet that contains two worksheets. One is the contents page
and the other is a template. The template has a command button when pressed
creates a new worksheet.

The new worksheets are allocated a number in sequence.

Each time a worksheet is created from the template I would like it to
1) create a order number 06/775 and put this into cell A1 on worksheet 1.
The order number in cell A1 is updated each time a worksheet is created.
2) put the order number into cell C7 in the contents worksheet.
3) when worksheet 2 is created update the order number in cell A1 to 06/776.
4) put the order number into cell C8 in the contents worksheet

If this is possible any help is appreciated.

Many thanks