A macro that can determine a file and extract data from it


I'm using Bluebeam Revu and exporting markups into a CSV file for different projects. I'm looking for a macro that can extract data from these worksheets without myself having to manually enter the file name, and then import the data into another excel template I use. I'm basically trying to automate opening up the CSV file and copy and pasting the information. If this is possible, I would love some guidance on the code needed.