Copy data from one Excel file to another Excel file

Hello,

I need support with a problem. Here is the scenario: All Excel files have the same structure:

  • Column A - Person in charge

  • Column B - Comment from the previous month

  • Column C - Comment from the current month

  • Columns D-Z - Data

The system should check if a file name (202503Sheet) exists in the previous month’s directory (2025/3). If it does, it should take this file and copy the data from columns A and B into the new file (name: 202504Sheet) into columns A and C, respectively. I can’t find a solution that helps me.