As per topic, I got a list of files in my drive. I would like to put the list of names of the files on a worksheet and a macro button to recognise the list and copy a certain column of data from a specific worksheet from the list of files into a separate file that I am on. How do i go about this?


Thank you
cheers
brad peh.