Invoice Number Generating

Hi, I am trying to generate an invoice number on a worksheet that is in a workbook that has 3 other worksheets in it.  I have tried the following a number of videos but it will not work, I think it i...