(Likely VBA) - Need to create multiple values Based on One cell's value

Hello,

I'm a VBA noob. I am building a sheet that will be used to catalog materials at our company.

Each piece of material will be given a unique code based on an accessionning system I devised (very basic).

Problem:
I need to do the following -

1.) There is a field that says "# of items". This will be a number that will be 1-26.
2.) I need to assign not only a letter for each number, but a letter for each integer before it.
3.) I need the output to go to another sheet

Example:

User inputs "14" as their number of units in Sheet 1

On sheet 2, in the corresponding row, 14 rows are created, the cells in one column are populated with the letters A - N.

Next, user inputs "3" as their number of units in Sheet 1 in the next row

On sheet 2, in the next available blank row, 3 rows are created, the cells in that one column are populated with the letters A - C

...and so on.

Can anyone help? Thanks!