Excel Template Population from Access "MS Office 2013"

[wingzerocustom]

Hello I was seeing if anyone could help me out on a very specific Excel Template population question. I am having an issue just trying to get started and don’t really know where to begin. I have some basic knowledge of using macros in excel but I don’t really think that could apply here very easily as I have 164 templates to populate as quickly and efficiently as possible for the situation.

I have added a pdf with a chart that I made trying to layout the situation and how things are connected. Basically each Excel Template is named after a CONFIG_ID. I am just wanting to populate the worksheet tabs (20 of them which are “OPTION_ID types”) with the options that are in the database tables for the specific options (Shown and explained better in the image).

If you have any other questions on the scenario feel free to ask and I will clarify the best I can. If you have any ideas about how I may be able to do this or where I can begin looking for similar scenarios I would appreciate it. Also any ideas that you have try to describe them in the simplest terms possible as I am not program savvy at all and I am new to this type of situation.

Thanks for all of the help.