Excel - VBA code

Hi all,

This is my first post here and am trying to learn VBA coding. I have adapted code from trumpexcel.com which allows me to make multiple selections in a drop down list for columns 7 and 11, no problem on Sheet3. I want to be able to make the same multiple selections from column 7 on Sheet6 as well, which the current code doesn't do. I am confused as the code doesn't state Sheet3 anywhere.

I would appreciate any help from my learned friends.

Thank you in advance,

Steve.