I have about 200 workbooks that I would like to add a sheet to. The sheet I want to add is actually a JPEG I scanned and pasted on a new sheet. I named the sheet (Change Over Worksheet) Is there a way to add this sheet to the other 200 workbooks with a macro copying from another workbook with the new sheet added? All the workbooks are in the same folder and sheet 1 are all different in every workbook. I can do this manually one by one but it will take some time. Thanks