Need help in generating auto running numbers from 1 sheets to another
(whenever I open a new sheet) for excel without having to keyin manually the
order#. The formats of contents are the same.
Example :

Sheet 1 : Master Sheet 2 : new 1 Sheet 3 : new 2
and so on
Order# : 00000 Order# : 00001 Order# : 00003