Hi,

I have a worksheet (attached) that once filled in, a button is pressed and a new sheet is created which stores the data, and the original sheet is then cleared so it can be filled in again. I would like to automatically chart the data each week as it is filled in - but obviously I can't tell the chart plotter what worksheets to reference until they are actually created, as I don't know what they will be called (it all depends on what date the data is entered). Is there a way around this problem?

Thanks!