Hi,

I dont even know if this is possible, but I'm sure you will tell me if it isn't.

I have an excel sheet that is generated daily (with a different files name each day). Each of these files is stored in the same folder on my drive.

Is it possible to create a sheet that will pull data from each of these files updating when new files are added to folder ?

The headers needed in this output file are:-

Amount / Currency Code / Processed Date / Release Date.

Let me know if I am dreaming or if this is a possibility?

Cheers

Jon