formula to Auto Number vouchers throughout XL sheet and across sheets in a single file.

[Redleader1]

I am using Excel 2011 for Mac.

I have created a template for set of petty cash vouchers fitting 6 to a single page: three down and two across. They are all identically formatted and consistent on each page.

There are several pages to each sheet and I have several sheets to a file. I only need to deal with one file.

I want a formula counter that automatic numbers each voucher in consecutive order. The cell where I want the number to go on each page is in the same position but of course the row number will increase. For example these are the cells where the numbers will be inserted on the first three pages (Column/Row number):

PAGE 1
B14 : B41
B30 : I30
B46 : I46

PAGE 2
B63 : I63
B79 : I79
B95 : I95

PAGE 3
B112 : i112
B128 : i128
B144 : i144

Page 4
etc...

I want the voucher number to have four numbers so it would appear as this:

Page 1
0001 : 0002
0003 : 0004
0005 : 0006

Page 2
0007 : 0008
0009 : 0010
0011 : 0012

Page 3
0013 : 0014
0015 : 0016
0017 : 0018

Page 4
etc...

I could put the numbers in manually, but I am dealing with over a thousand vouchers.

If possible: until I have locked off the sheet, I want the numbers to update if I delete a whole voucher (or remove the formula from the cell). For example if I delete number 0125, instead of having a missing number 0125, 0126 becomes 0125 and 0127 becomes 0126 etc.

Can anyone meet this challenge?

Many thanks
RedLeader1