Search string from multiple sheets

Hi All,
I have a small requirement where I need to search quite a few excel sheets for a particular string. Once I find it. I need the compete row to be copied to the search file.
I have attached the files and search file.
• All the files will be saved in the same path
• All are excel files
• Few files may have multiple sheets
• Files will keep increasing by one every month
Hope you can help me with this