Vba to run macro for multiple excel files within a folder path

[criscrks]

Hello,


I want to record a VBA that uses =index,(match),0)) formula into the same cell for multiple excel files. The files will be in .XLSX format and will =index,(match),0)) against a separate excel file. I want this function to work for a folder path containing multiple files Please let me know if this makes any sense and if possible.


Here is the example of how the formula will be.

=INDEX(ZAZZZZZZZ.xlsx!$B:$B,MATCH(A2,ZAZZZZZZZ.xlsx!$D:$D,0))



Thanks,
Criscrks