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 a...