Extract instances across multiple workbooks

[Desertbird]

Hello, I am trying to create a sheet to help pull data from multiple workbooks. Basically, I want it to list all instances that the first column matches the name. Each workbook is in it's own folder. Is this possible with just a function? Such as a filter function that can go across workbooks? There are about 800 workbooks in total. I'm not familiar enough with VBA but if anyone has suggestions on where to start with a function, I would really appreciate it.

 

[BSALV]

how do i know the path & names of those 800 workbooks ?
Have they all similar names ?
The easiest way is then to open them all one by one, do the checks, close them and proceed with the next.