Inserting pages from another workbook

[Britbiker2]

Hi

I often have test sheets to write for a large number of items  (workbooks), that essentially are exactly the same in format. However two pages although the same in all work can not be written immediately.

Is there a way of writing them separately and automatically having them inserted into all the other work books without tedious copy and pasting?

[#2]

@Britbiker2 

You can inset a worksheet from another workbook.

Open both files, right click on the worksheet you want to insert into the other workbook -->Move or Copy --> from to book choose the workbook you wan to to insert the sheet, and check the box create a copy

* If my post helped you, please click on like.