Hello - let me preface this post by stating that I am a novice in
regards to Macro programming. That being stated, here's my issue.

Every month, we receive hundreds of Excel files from various business
units. The filenames are always different and they change
month-to-month, but the template format they use to input their data is
the same across the board. Thus, for example, cell A1 always contains
an account number within all these files, cell A2 contains a name, etc.

Each workbook includes two separate tabs. What I need to be able to do
is automatically extract data within specific cells for all these
workbooks. Currently the files are in four separate folders, but they
could be moved into one if that was an issue.

Thanks for your suggestions.