I have several thousand spreadsheets, one each in a path (example) of
\level1\level2\Year\Month\Folder\file.xls. I need a macro that will
open each file.xls, copy cell G9 and past it in a "summary" file cell
A1. Then go to next file, copy G9 into A2, etc. The copy/paste part
seems pretty straightforward, and loop is obvious, but I have no idea
how to write code that would generically do this on every xls file in
this many branched path tree. Is it possible? I'm a VBA novice, and
appreciate any help.