Can anyone help a novice to add a field in an Excel workbook that auto
generates a number (starting with the first one I tell it to) and then auto
generate the next consecutive # after maybe clicking on an update button that
also would clear the form?

Maybe Excell is not the way to go. Maybe Access or something?