Auto populate cells with numbers and letters?

I cant seem to figure out how to auto-populate or drag cells to copy downward in this way:

1A
1B
1C
1D
1E
2A
2B
2C
2D
2E
3A
3B
3C
3D
3E
etc, and so on... through 200 and i don't want to have to hand type each number and letter... Let me know if i explained well enough what i need done. Thanks

Fill in the first 5

1A
1B
1C
1D
1E

Then use this formula:

=LEFT(A1,LEN(A1)-1)+1 & RIGHT(A1,1)

And drag down.

Then, if you want, you just copy the column and paste as values.