Need to auto copy specific column data from 1 wb to another wb without opening files

I have two Excel files, one (source file) named “Group” that is emailed every night and the attachment is placed into a Network shared folder. And the second file (primary) named “Exec Report“ is located on a network share in a separate folder path. Every night a new “Group” file is auto populated into a folder with the same name so it over rights the existing file so there is only 1 file in the folder with updated data. I need to be able to get the last line of date (these are total values for the month) in the “Group” workbook in columns D-L copied and pasted into the “Exec Report” workbook on B20-J20. The rows will vary depending on amount of data for the month - could be D6-L6 today or could be D80-L80 by the end of the month but it is always the last row and is always D-L that has the data being copied. The idea is that this is done without either file being opened.
Thank you for your time in assisting. If there is a better way than VBA or Macros I am open to suggestions.

Your best bet is to UPLOAD your example with solution (see forum rules) so we can take a look at it. Generally, the file would need to be opened as Read Only file to 'pull' the info out of it. VBA code could pull the last row of the current region to get you what you need....ah but where to put this info? Many details are left out, so please update.

My apologize that I did not upload my files for clarity. I have now uploaded them. I have highlighted in red on both files the data impacted by my request. "Group Report" is the source file where the last line of D-L would need to be copied and pasted into "Exec Report" in B21-J21.