I have this invoice management excel sheet that automatically transfer data in another sheet after clearing using a button, I just need to automatically generate the invoice number in the main invoice sheet,so when it copied to the record sheet it is in sequence, also I wanted the format to be as 001, 002 and so on.

Please help.