VBA Copy data based on name & paste into workbook w/ named tab

[msquared99]

Here file 2.

The macro is in a stand alone workbook and is activated by a click button. When the macro runs it allows you to navigate to the folder and opens the file Raw data from CVENT - sample. It assigns this workbook "FileName". The macro then opens the Survey Summary Template.

So, what I am trying to do is have the macro copy the data in column B into the Survey Summary Template that matches the tab name to the name in column B.

So far my attenpts have failed as I am just learning VBA.

Thanks for your time and help.