Macro to extract data from multiple workbooks, specific sheet, specific cells

Hello,

I am trying to create a macro that will extract data from multiple workbooks (closed if possible) and summarize into a new sheet.

In each workbook, I have a sheet named "Indirect Build Up Reference" and from this sheet I need the data from cells E271:K274.

I've been using the code from this site which I found on another thread here: http://www.rondebruin.nl/copy3.htm

But it's a little complicated and I keep getting a "Compile Error."

I've attached the code I have so far in a Word document in case anyone can work with it.

Any help or suggestions are greatly appreciated!

Crissy