Hello. I have several documents, the documents are similar in structure, the names of the sheets in the documents are the same. The differences are only in the information on the sheets. Now I have changed the information on one sheet and I need to replace this sheet in each document with a new one with the changed information. How to replace sheets in several documents at once? I have 26 documents and it takes a very long time to open each one ..
1. I have several separate files (these are multipage documents) 2. Each file has identical sheets (the same sheet in each separate file) 3. On this sheet, I have changed the information. 4. Now I need to replace this sheet in all files. 5. Now I open each file, delete the old sheet and insert a new sheet with the new information. (this is not convenient at all, given that the age of automation is already in full swing)