Case insensitive search for string within folder of excel files

I need to be able to do a case insensitive search for a string in a specific folder containing multiple excel files none of which have the same number of worksheets.

The result of the search should be made available in a new file which will specify where the matches were found.

I look forward to your kind help in this regard.