How can i copy excel range and paste it to multiple workbook

Hi guy, I

1)i want to copy these range (G1:G50000 to W1:W50000) to other worksheet (the name is change every day due to i downloaded it everyday)

2)how to paste it everyday since target name sheet is change everyday

please help me



This is the pic of copy range
peoplehelpme_0-1696897879249.png

and this is all file i want to paste it
peoplehelpme_1-1696898095448.png