combining multiple different excel files with the same format in to 1 worksheet

Hello,

I would like to know how i can put different excel files in to 1 worksheet. they have the same headers. Normally I can just copy all the files but there are like hundreds of files... This is how the data is organised in folders:

(folder) Event logs
- (folder) 2012
- (folder) 2013
- -(folder) January
- -(folder) February
- -(folder) March
- -(folder) April
- - -(folder)1
- - - (folder) 2
- - -(folder) 3
- - - (folder) 4
- - - (folder) 5
--- -worksheet 1
--- - -worksheet 2
--- - -worksheet 3
--- - (folder) 6
-----worksheet 1
--- - -worksheet 2
--- - -worksheet 3
--- - (folder) 7
---- -worksheet 1
--- - -worksheet 2
--- - -worksheet 3
--- - (folder) 8
--- --worksheet 1
--- - -worksheet 2
--- - -worksheet 3
--- -(folder) etc...

as you can see i need all the worksheet 2's from all the different folders..
is there a way?

thank you