Can I pull the same cell out of every workbook in a folder? (1000 workbooks)

[c.clavin]

Hi guys, I'm trying to make a client database for my previous year(s), pulling the same cell (C3) and inserting them in a new workbook would save me HOURS of work. Is this even possible? Thanks

 

[Micron]

I don't see why not. You'd either need a list of file paths (e.g. in a sheet) or loop over 1K files in one folder or you'd need a recursive function that moves through subfolders. I suppose each copy/paste would go into a cell below wherever you start from in the target workbook.