将数据从excel文件夹导入特定的excel文件进行分析

I'm working on a project where I am supposed to collect a specific table of data from weekly reports(excel documents), the data is sorted in lines, where each line contains a date, number of minutes, a code(1-7) and a comment.I'm working on a project where I am supposed to