Choosing a string based on a sheet name from external workbook

[TheReefGuy]

Hi guys.

Having a little bit of trouble.

I'm trying to "look" for a sheet name from an external workbook, and then based on the sheet name, the code chooses a string.

Example, "Workbook_1" have "Sheet_1", the code checks if this sheet name is in the list, and then choose a String.

Regards

TRG