Re your point 5, will the data always be the same, or do you want to be able to add to or change the ranges on the worksheet and have the code pick it up? (Basically I want to know if we can hardcode the data into the code). Also, does the picture box in the source workbook always have the same name, or is it the only picture, or do we have to use the location of it?