How to select and load multiple rasters from one folder in Arc?

My situation is probably familiar to some of you. I do have 3 folders with houndreds of maps in it. I do have also overview sheet, which helps me generate list of rasters that I need. How do I select them automatically from houndreds of others?

Its an issue which occurs for me from time to time. Manual selection is really inconvenient.