Auto update my numbering system in excel

Hi,

I would like Excel to control my numbering system in column A, Automatically. Im wondering if this can be done?

If for example I wanted to add a new item above row 19, to keep things sequential, I would want to make this number MCC1/xx/P008, however this would mean that I would have a duplicated number below it, i.e. the existing MCC1/xx/P008, which is currently on row 19.

My question is, If I was to do as I described, is there something I can implement that would auto revise the numbers below row 19 to avoid duplication and keeping things sequential?

Thanks, I hope I made sense!