Auto invoice number generation?

In my accounts workbook i record data for each and every invoice that i raise (invoice is on a separate workbook) Let say the last entry was for invoice 14050 (on accounts WB) is there a way that when i open the invoice WB to raise a new invoice that one of the cells automatically looks in the accounts WB for the last entry (14050) and then automatically populates the cell consecutively ie 14051. Lets say invoice number is recorded in column C in accounts WB and i want populate Cell A1 on invoice WB?

Many thanks in advance for any advice given.