merging sheets in different workbooks into a master sheet

Hi Guys,

I'm quite new to VBA and macros, and I came upon a challange which cannot be solved through formulas without pain

I'd appreciate if you could help me out with this one.

The scenario:
1) 110 workbooks with 2-3 sheets (one sheet for one week)
2) I need all the sheets in one workbook
3) I need one master sheet, where all the inputs from the sheets from a1:e100 are copied together below each other (producing me a table ranging from a1:e33000.

Is there a way to make this happen?

Thanks in advance,
Mark