Yes, a macro can be written to do this. It doesn't even sound very
complicated, actually. Let me rephrase to be sure I understand it correctly:
You have a spreadsheet that starts with one worksheet, which has a list of
questions on it. Your macro is to run down the list and do the following for
each question:

1) Create a new worksheet for that question, and copy the question to that
worksheet.
2) Select the number 12, 16 or 24.
3) That many times, pose the question to the user and get his answer. Write
each answer on the worksheet that was created for that question.

At any point, the user should be able to hit a button that causes the logic
to stop at that point, without losing any of the data entered so far, and
when restarted later to take up the process at that point.

Yes, this isn't too hard. Do you need hints on how to write it? How much
VBA do you know already?

--- "TGalin" wrote:
Is a macro capable of doing these things?

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.