Searching multiple files and copying text
 

I need your help with the following situation:

I have multiple excel files that have the same exact structure.
Have to search across all of the files for two different strings,
which should both be prompted (stra and strb).
This information prompted should be compared, (stra) with the values
in column c (if this is true), then strb with the values in column d.


If both criterias are located in the SAME row, I have to display the
information on columns e and f.

Thanks to all of you for your help.

Marcelo