summarise data from mulitple workbooks

Hi

I am completely new to working with visual basic and have tried to create some code but with very little success. I am trying to create a summary sheet which will collate data from multiple workbooks contained within the same file. The summary sheet needs to collate cells B42 to H63 (constant) of each worksheet - example attached.

Any help would be greatly appreciated

Regards

stuart