Rolling 12months and creating a graph from data

[AsherD2]

Hi

I have an excel workbook and want to have on one sheet with the results of reports that I get on a monthly and want to keep track that I do receive them and create a graph from the data.
I have have on the second sheet the results of the data that I need to formulate and the formula I have been working with.

What is the best way to automate my monthly data calculations to automatically move over once a new months data is entered? Currently, I will just manually pull the formulas over.

 

[mick0005]

Your images are not visible. Please see the link in my signature to learn how to properly post examples of your work using the HTML Maker. You need to show us what you have now, and what you're expecting as a result.

Also, may I suggest you use some bullets to describe what your problem and requirements are? The sentence above is not clear... I don't know what you mean when you say "I have have on the second sheet the results of the data that I need to formulate and the formula I have been working with. " Maybe this is because I can't see your images. I'm not sure.