I have written the following code to select files to be copied
once I select a file it appears in the message box
I would also like the file name selected to be copied into Col A from row 2 onwards on sheet "Macro"
or e.g. if BR1 sales May 2019.csv is selected first, BR2 sales May 2019.csv...