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