Changing tables for Make table query using list box

[realstandman]

I am trying to accomplish changing the tables using a list box for a make table query, so I can take data from a user selected linked table and output to a table other queries will use. How can this be done or is there a better way?

 

[realstandman]

I have tested using a macro and can do this, however how would I give the user an option to change the source object name?

Thanks for any help,