Multiple workbooks with multiple worksheets summed up in 1 workbook

[xanne]

I am a beginner excell user and I have complicated problem. I am doing some research and I have a lot of results from patients in different workbooks, a 100, with each 10 worksheets. The workbooks all look the same but the results are different in each one. Now I want to create 1 final workbook that contains all the results summed up in the same design. I found the formula to pull data from 1 workbook and put in another but that means I have to pull 100 to 200 results from each workbook and put it in the final file.
Is there an easy way to have all that data summed up in 1 file?

[arthurbr]

Hi and welcome to the board,
one of your compatriots has very nice solutions on this site
Check this title out