Creation of Array (but open to ideas)

Hi everyone,

I'm completely stumped and can't seem to move forward.

Background:
I have a worksheet that is used by multiple people to gather information from third parties. The format is something vaguely like a pivot table, but in look only. My boss is totally married to this format so it cannot change. (tab "Report" in attachment). The "report" uses dropdown lists that are fed from tab "Dropdown Listing". There is vba that allows for choosing multiple entries into each cell delimited by comma.

I then take this sheet and convert it into an import into access using a macro. (tab "Data Tables - Mult Entries"). All data is text.

Load it into access along with everyone elses updates. There are about 15 people with these sheets that are actively updating daily and we load into Access so we have a place to join all the data together.

So here is the problem:
I need to then take the output of the access table, which would contain values for every column (not just those shown in tab "Data Tables - Mult Entries". The other columns come from various sources) and make it look like tab "Report"!

I've looked at over a hundred posts and have come close but nothing seems to work well. Any ideas would be great. I'll try anything at this point!!!!