Manage/ write to same cells in multiple sreadsheets in a folder.

Morning!,
I have multiple files that I need to add data to from a master spreadsheet. I need two text selections to be copied to different tabs and also a new tab to be inserted into each spreadsheet. At first I thought this could be accomplished by using the "group" facility in excel but alas it does not seem to span between different files. I have found a solution online but it involves adding code to each spreadsheet in the folder, which will probably take as long as performing the edit manually. Has anyone used any vba code similar to this before?
The text selections are always the same size to go to the same cells.

I have written many files that save data to other files, in many cases as I think in your case I use a combination of Sheet calculations and VBA to do the actual transferring. Take a look at the attached File which I have modified from a similar project of mine. It will not work on your computer until your enter your relevant Data in the "Calcs" sheet. I have tested it here and it works for my sample Data Files I created. One thing The pages will require names, I hope that is not an issue. Also I was unsure about the adding of a tab to each Data File, I have remmed out that code in this example.

Thanks Catman50 This looks to be very helpful. I'll have a play with this and report back.

I have changed the path to my local drive and created 4 data files (DataFile1.xlsx, DataFile2.xlsx, DataFile3.xlsx, DataFile4.xlsx) and changed tab names to DataSheet1 and DataSheet2 in all of them.
Enabled macros and ran and have a runtime error 1004. Method 'range' of object '_global' failed.
Debug highlights this line in code:

Please Login or Register  to view this content.

DataFile1.xlsx has been opened by the code when the error occurs.

Sorry for the delay in response.

Did You Set up the Data Ranges Names on your Datafiles and on Your Masterfile as Xdata1 and XData2? if not you can use the Range address's as Per amended Example. If the actual Cell Ranges are not the same the table could be amended to allow for this.

Thanks Catman this worked well. It is better with the range addresses as no preparation is required within the target workbooks.