When I change the line of code you mention, the parse macro breaks, it copies the first item number fine but after that everything is blank. Any other ideas? Also if I change the page format on the origin sheet such as borders and the like will those formats be copied over to the new sheets? After all it is much faster to change that sort of thing one time then do it every time I need one of the sheets printed.
this is what I came up with, which is faster then the other way I was doing it, but not as fast as before I made changes to it.