I'm not sure I follow the 1st answer. The "starting new everytime" leads me to think you mean new Workbooks rather than worksheets.
At any rate the attachment is just an idea. Hopefully other members will chime in on this.
None of the tab names matter but, and it's a big but, this relies on the summary sheet being identified by the codename Excel gives it. If your 1st answer is referring to the summary sheet being replaced we'll need to deal with that in another manner.
Give this a look.
I'd leave the BLANK sheet as a template, do the "move or copy..." thing to make copies to try, it has the necessary code with it, right click the tab and "View Code" to see.
Hope this helps or gives some insight towards the solution you're after. Return with any questions.
Good Luck
NoSparks
|