I need to search for a workbook (in the folder there are ca. 10 of
them). In one workbook I have a dropdown menu, where the user can
choose a keyword According to that keyword, I need to choose the right
workbook and do some data transfers to the first book. But that's
another story, first I need a way to get the right workbook.

I'm waiting for any help!