Make Table query: can I name the new table as a user-defined parameter

I am building an Access database where I would like to save various iterations of data (what-if simluations). I want to be able to save each iteration, rather than overwrite (and then have to recreate once we've selected the "winning" option. So SELECT [sourcetable] INTO [new table] works only for iteration #1.
I know the user can just go to the database window and rename the new table before running the Make Table again. That work sfine for me, but once I pass this tool off to a new user, I'd prefer to keep them out of the database window (assuming the user can name the new table as it's created).
Thanks for any ideas.

Look at "DemoTableNameQryA2000.mdb" (attachment,zip).
Open Form1 and try.
Look at VBA. Adapt it in your mdb.

I forgot;
write; MyTable or [My Table]

Thanks for this code, I think it is going to work great. I have a little more work to do before I can test it in my app.
I initially posted some followup questions, but have answered them on my own by playing around with it.
Thanks again,
Erin