Add data from a sheet that was inserted via a Macro to display on a chart.

[tiroler98]

I am trying to build a file where I add a new sheet daily via a macro. Then we are adding production data on the new sheet and then I want to use some data summary on a summary sheet. The summary sheet would have a predetermined cells for the data for each day from the inserted sheets. From the summary sheet I then want to create a chart. I can do the macro, that is no problem but how can I ensure that the data from each sheet goes into the correct spot which of course is different for each new sheet. 

Thanks for the help!

[#2]

@tiroler98 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

*Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).

In order not to be misunderstood, in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)