Hey everyone,

I have an excel database that I have created with about 20 worksheets and over 45 macros. Each macro takes a section from one of the 20 worksheets and copies it to the main worksheet for an easy search function and user friendliness. I have a dropdown box with each of the 45 sections listed as selections.

I need the coding/macro that will run a macro whenever something is chosen in that drop down box, and will run the appropriate macro. For instance, if someone chooses Accountability -Employee, I would like for the AccountabilityEmployee macro to run which would populate that page with the corresponding information and so on for all of the 45 macros.

Obviously, I don't want you to give me the entire coding for the whole 45 macros, but if you can please just get me started, I would appreciate it.

Thank you.