So I have a first sheet in my workbook, "Sheet1" with a table that has some data and a few formulas based on this data. Let's say that for Sheet1, cell D2 is equal to the data in cell C2. I want to create a macro to open up a a new worksheet, "Sheet2" and copy the table from sheet 1 into it. All the data from "Sheet1" will be blank at this point. So Sheet2 will have a new table with the same columns and rows as Sheet1.

For Sheet2 I want it to reference the previous sheet's (Sheet1) Cell D2 and I want it to add the active sheet's (Sheet2) Cell C2. I want this to happen 30 times. So I want when the macro opens up "Sheet3" for it to reference Sheet2, and so on. I have a few Sums like this and an average that I would like for it to run.

Example