I have this code that I was trying to modify to loop through then paste to a new worksheet. I can't seem to get the loop to work. It will work on one sheet and that's it. It isn't a must have, but it would really be nice to be able to copy to a new blank worksheet rather than within the same...