I am trying to do the following.

Sheet 1, each cell in the range B4:B54 will contain one question, thus
altogether I have 50 questions. I would like to create a macro that when I
run it, a message box will appear.

The message box will randomly ask me each question from the range B4:B54
either 12, 16, or 24 times in a row/consecutively before moving to the next
question. I would also like the message box to contain a field big enough
for me to answer the question inside of each time it is asked.

After I type my response and press enter, I would like a new worksheet to be
created. In the new worksheet I would like the question that was asked to go
into C2 and a record of every answer I gave to go into the new worksheet
starting in C4 and going down to C16, C20, or C28 depending on how many times
I answered the question in a row/consecutively whether it was 12, 16, or 24
times. Finally I would like to have a way that I can exit the Macro but not
loose the data that has already been gathered. Is this possible?