There are a few strategies to address this endeavor....
I am calling your data  file 'Source' and the 'Target' is where your data gets
pasted into.
A few questions for clearity:
1. Is the 'Source' file always the same name?
2. Are the 'Source' worksheets  (tabs) always the same number or name?

I was thinking of this:
Have the 'Target' file (or sheet) have the logic to select the 'Source' file &
bring the data into the 'Target' file. It's just one perspective on a solution
option!