Insert Sequence Number

Question

Hi new to kutools here.
Is there a way to add a sequential range to a group of customer codes for example in kutools? I know there is the prefix option in kutools but that would mean I would have to create 1000's of different sequences. What i need it do do is use the cell reference instead.

Thanks in advance.

E.G:

ABCD0001
ABCD0002
ABCD0003
DEFG0001
DEFG0002
GHJK0001
LIKJ0001
LIKJ0002