I want to be able to write a macro that when run looks at a user entry
(numeric) and based on that answer, runs a specific corresponding
macro.

Example:

User open the workbook and answers the prompted question with a 1 and
clicks the "submit" button. The macro looks at the answer (the 1) and
opens another workbook and runs macro 1. If however the user entered 9
then the macro would open the workbook and run macro 9.

Is there a way to do this?

I know how to open another workbook and run a macro from a macro. The
part I don't know is how to have the macro decide which macro in the
other workbook to run.

Any assistance is greatly appreciated.

Don