Combining multiple Excel files into 1 Excel database.

[MiksLacis94]

Hello,

Quick background on the idea in my mind. My company employs people from multiple "Agencies", 4 to be exact. On a weekly basis I save how many hours each employee worked from which agency in seperate Excel files. All of the files have the same columns, only the data in each file is different. I want to create 1 Excel database that is linked to the existing files but can also take new files from new folders each week. 

I am looking for some tips on how to start creating a data module in Excel that has 1 main file (database), multiple folders (based on a weekly basis e.g folder week 1, folder week 2 etc.) and multiple Excel (agency 1, agency 2 etc.) files in those folders. If I create a new folder for a new week and put in that weeks files in it, I would like to be able to refresh the main file so it updates the information. Then I will use Pivot tables to get the information I need. 

Any help will be appreciated.

Thank you!