Creating a new Invoice and Auto Invoice Number in Excel

Using an Excel Invoice Template, how do I create an auto Invoice Number? Say I have a new invoice set up in 10 worksheets to 10 various vendors and I want each number (alphanumeric) to be generated automatically.  I know how to reference a cell in another worksheet but how do I make it run sequentially in separate invoices?