Get Data From Entire Directory

I can't seem to find a solution that works, so I don't have an example or starting point, so I'll try to explain as best I can

I need the data from certain cells in every workbook in "C:\Housing Data" All workbooks have unique names, and are in subfolders.

I'd like column "A" to be filled with the name of each workbook,
column "B" to be filled with the data from cell "H26",
column "C" to be filled with the data from cell "F32",
column "D" to be filled with the data from cell "M32".

Example:
[

550 W. Evergreen Terrace	60625	5/15	6/2
202 N. Pineapple Dr.	60625	3/12	8/14
18 W. Stapler Ave.	60339	3/13	3/15

Each row would be from a different workbook.
I've tried multiple solutions, but I keep running into a file system object error.

Thanks!

Correct. Thank you.

"Zip Code", "Date In", "Date out" work for me. Thank you very much.

Hi Leith,
Each workbook has multiple worksheets, but all the data I need will be in the sheet "FORM"
(So, for example the "Zip Code" would be in

Please Login or Register  to view this content.

And yes, all data would be in the same place in each workbook.

Thank you! You're very kind. Did you attach it?

Gotcha. Thank you so much!

Hi Leith Ross,
thanks for your valuable code. is it possibile to change your code just to extract data from all the files in subfolders inside a folders irrespective of columns.
Thanks in advance

Hi Leith,
Unfortunately, when I click "Run", nothing happens. I went into the VBA editor, copied the exact file path that is on my computer and ran it from there, and still nothing happened. I looked through the code, and I couldn't find a reason for it not to work, but I don't know a whole lot about VBA. (by the way, my version of Excel is Excel 360 Pro Plus)

OH, I'll add .xlsb to the filter. They're binary files. Thank you.

It works! Thank you very much, cut down my work by a few hours.