automatically create summary

Hi,

i am doing research for my university and I must analyze a lot of data. Maybe there is an easier way than manually copy and pasting tons of tables?

I have around 20 excel files, each consiting of 2 to 16 sheets.

The sheets are all the same. My task is to copy and paste a particular part of every sheet into one new "summary sheet".

Can i write a makro or anything that copies the cells A5 to BU16 from every sheet and file inside a specified folder and pastes it into one single file?

Sorry, i have never touched makros or anything alike before, but I know they can do some powerful things....
thanks in advance

Tom

Dear RoyUK

your code looks pretty sophisticated. I managed to let it open .xlsx files, by changing every xls to xlsx, but unfortunately it only empties all my files and makes them unusable without creating a summary.