Repeat text in cells and add one to the number

I'm trying to create a workbook that will automatically fill in text and numbers.

For example, if I type GSK09C-ARIC-0186 into cell A1, I want that to appear in cells A3, A5, and A7. Then in cell A9, I want the number at the end (0186) to increase by one, thus displaying GSK09C-ARIC-0187 and having GSK09C-ARIC-0187 repeat 3 times before moving on to the next number (0188). Thus making cell A1 the starting point for the numerical order (ie typing 0300 at the end of GSK09C-ARIC- will make the rest of the cells automatically update to make 0301, 0302, 0303, etc.)

I've been using the =Left formula to get the GSK09C-ARIC- to repeat but I cannot make the number increase by one.

Any other formulas I can use to assist in this process?

Thank you,
Kyle