I want to copy files from multiple subgolders to a single folder and record in an Declan spreadsheet every file name copied and the path it was copied from. The solution can be an excel spears sheet or application, I don't mind as long as I can do the following. I want to be able to open a macro excel spreadsheet or application that has a button command that allows me to browse to and select a top level folder which will have subgolders below, once I select the top level folder I then want to be Able to navigate to a folder (destination folder) that I want all files contained within the subgolders to the copied to destination folder and every file that is copied to the destination folder should be recorded I a row I a spreadsheet which I can name, two columns will exit I. This spreadsheet, file name and the path it was copied from. Easy!