in separate Excel files. You can now create a macro that opens each report file, identifies and copies the relevant data, ...

I imported my current Excel workbook into LibreOffice, which did the job just fine. The workbook has multiple sheets with ...