loop Search, copy paste,next search, copy paste ...

Hello everyone, I’m new to excel forums so bear with me on this one.

I’ve tried a bit of everything, but my programing skills with excel are limited.

The idea i have is the next:

Got 2 files:
1º - Where all the details are found and from where it will be extracted.
2º - Where the data will be copied to. The cell that was searched for, will be searched in this file too to paste

in other words, I need to be able to extract and make a loop search of all that is in Range(AH13:AH67) and for each that is found, run the code that comes after(or something similar)

Or that list or the list that’s in the file 1 in column AB to make the search faster.
(This last list has never the same amount of weeks and cells occupied. Only the ones illustrated in the document.)
Ill post the 2 files and paste the code:

Please Login or Register  to view this content.

Ill appreciate all the help given

PD: sorry if ive spelled something wrong

***Code updated. Had a little mistake.

************
*******EDIT:

At the end i worked it out and some other bugs that came up:

Please Login or Register  to view this content.

Figured out this much so far.
Now i just need to make the search cell jump to the next cell, any ideas?

Please Login or Register  to view this content.

I dont know if i should be using the "offset" to change to the next cell.


This is what i got untill now:

Please Login or Register  to view this content.