Paste data from one sheet to specific sheet in multiple workbooks

I have a set of budget files (all the same format) that need to be updated. I have one file where I am putting the macro, and this can remain open while I cycle through the workbooks in a folder. I would like it to open the files, go to the source data file, copy a range, and paste it in a range on the target files. I figured this would be simple, but I haven't been able to figure this out. The code I have written (stolen from other coders online) feels like it should work, but it gets hung up on the [wsP.Range("T2").Select] statement. Clearly, it cannot find that worksheet, and I am having difficulty writing code that goes back and forth between workbooks when one of the workbooks is variable, and the name changes often. I started writing macros about 2 weeks ago, so any help is appreciated.

This is my first post, and I am not 100% sure on how to post the code.....hopefully this is right, and if it isn't, I apologize.

Please Login or Register  to view this content.

You can mark this as solved. Thanks so much for your help, JBeaucaire. I don't know why I had such a problem with that. I probably changed the code 20 times, and just had problems switching from the copy file to the paste file, and back. I think I got confused on the naming of a variable file, and how to go back to it.