custome Lottery with raffles

hello there I am trying to create a spread sheet that has in Sheet 1 Column A and Column B with the corresponding titles "Participants" and "Raffles" . The Column A and Column B does not have a fixed amount of participants or raffles , which means in one day there can be 5 participants but in the next day there can be 500 participants . Same happens with Column B.

Now at the cell F1, I have the total number of raffles (the sum of the total ruffles from Column B.

What I want to do is a code that when I have in Column A , for example 3 names FireDragon, Ulothar, Ioana, and the corresponding Values in Column B are : 100, 50, 5 to get the results in Sheet 1

FireDragon 1
FireDragon 2
FireDragon 3
...................
FireDragon 100
Ulothar 101
Ulothar 102
Ulothar 103
......................
Ulothar 150
Ioana 151
Ioana 152
Ioana 153
......................
Ioana 155


I do include a sample file as well to show you what I want