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