loop through files and copy last column

Hello,

I need a to loop through all excel files in a specified folder and copy the last column of data to a destination worksheet. Can someone please help me with the code for this, i do not even know where to start.

Thanks

hi, gsurge, attach couple of sample files and result file.

i cannot really do that, but its a straight forward worksheet. do you have a sample code I could work from?

why not to use search?

example: http://support.microsoft.com/kb/139724