Is this possible to be done with multiple workbooks and every worksheets?

Main file = New data, I would like to add row "42" and change row "53" "P13QR01-2201" to OLD file of row 52 "P13QR01-0800".
Folder:
C:\Users\User\Desktop\Macro VBA

Because I have a variety of file names and a different*number of worksheets, it would be even better if I could disregard all of the file names and simply alter all of the different workbooks and worksheets in the folder.


I hope the pictures below illustrate my need…Thanks!

New "Main", the file data that I would like to copy to Old files:
1.jpg

Old file:
2.jpg

Folder:
Folder.jpg