Pull column from closed worksheet to master

Hi All,

I am looking to pull data from a column in a .xls file into a summary spread sheet.

I have is a heap of files spread over several folders. I want to import column 'C' from these .xls files into a summary excel file. I want all these imported columns to be in the same worksheet, but different columns (obviously). So Book1 goes to column A, Book2 to Column B and so on

As I said before I want the summary sheet to update without having to open the individual files.

Is this possible and how does one do it?

Cheers

Unless I've misunderstood, it's INDIRECT.EXT that you need. See here:

HTML Code: 

Thanks for this, unfortunately, the INDIRECT.EXT function doesn't seem to function in Excel 2010 64 bit. Is there a VBA script that someone has developed?