VBA_Vlookup different source file names

[excelnoob1991]

Hi all, I need some help.
I've been going through this thread but I am so lost, either that or it's just not my day.

I have several reports that I would need to update on a regular basis. They are mainly details of employees in the company.

Is there a way I can use VBA to vlookup this automatically but from different source files? My source files are directly from the system I use and are always up to date but I rename them so I know when these files are downloaded e.g. Biodata_as on 11 March 2024.

At times, I am required to vlookup 2 different files e.g. Biodata_as on 29 Feb 2024 and Biodata_as on 11 Mar 2024 as these employees have left and will no longer be in the 11 Mar 2024 file.

Manually doing this on multiple different reports is pretty time-consuming
Hoping there's any good samaritan who could help me with this.

Thank you in advance =)

 

[LazyBug]

Hello!
The answer is highly likely to be positive, but more specific data is needed. Would you post an example of tables with specific book names, sheet names, ranges, and formulas.