Copy from multiple files cells adjacent to specific word

[Elena91]

Hello,

I got about 100 excel files that are tables converted from PDF.
They contain two data I am interested in copy in a unique file.
I would like to use a macro that:

1) goes through different files
2) searches for two specific words
3) copies the cell adjacent to the right of the two words I look for.

The cells I want are placed in different positions through all the different files.

I tried to add few lines in the following code, but no success... Searching Through Many Workbooks (Microsoft Excel)

Thanks a lot, to those who will help me

 

[ouvay]

searches for two specific words

Where would these two words be? like where are the lookup values?
and the ranges to search in? would you care to share some data samples for me to work with and better understand your needs