split column into multiple files into multiple columns based on another file

hi
I would split column B into files PUR1,PUR2 into multiple columns into column B,C,D,E based on splited data file SEARCH into columns B,C,D . the result should be in first sheet into files PUR1,2 and should replace the data every time run the macro . I put the expected result in both the files in sheet result . I have about five files in the same folder whit the same structure as in PUR1,2

thanks in advance