Macro for copying values to another worksheet

Ok, so I am working on helping a friend with his new venture, so his resources are limited. I offered to help with setting up something in Excel, and while I got it to work, I need to it be a bit easier and user friendly.

What I've created is a product tracking system for him that he can put numbers in to track his products etc.

The workbook has these pages currently.
Template
Overview
Product One
Product Two

I have a macro that can be run for the Template page that will create a new page for Product as it is added by him.
What I am trying to do though, is when that macro is run (or a separate macro if needed), it would add some values from the new product page to the overview page. It would also need to add it under the last line added, so that way when a 4th product page is created, it would put it under Product Three on the overview page. Currently the cells that need to be carried over to the overview page would be O47, P47, U47, and V47 (more would be added later I am sure). These cells though are formulas that return results based upon his requirements on the product page.

So when the macro carries them over to the Overview page, it would need to be a referenced formula. Here is where I get lost. The first macro I tried worked, but only for the Product One page. The next attempt I had worked for any Product page, but only copied the value, not the formula so if I was to add inventory, the overview page wouldn't reflect the change.

Is what I am attempting to do here feasible?

Sounds like you might be referencing cells.value instead of cells.formula, but without a sample workbook it's hard to conceptualize.

It is feasible but like Poizhan said if you attach a sample workbook it will be easier to help.

Sorry for the delay, I was having a hard time getting this to load.

This is just a quick sample of what he wanted. I have the Template and Overview pages and the Macro that when run, copies the Template page and creates a new worksheet.

When I create the new worksheet, I need (for now, though once I get this I should be able to get the rest) from the new sheet, O47 U47 O71 and U71. O47 adds all the values from range O30 to O45, which are copied values from the left side of the page IE O30 = K6. Same principle applies for the other 3 values.

With the first new sheet, O47 would copy over to the Overview page, into C4. U47 would be E4, O71 would be G4 and U71 would be I4. When the 2nd product page would be created, the O47 etc would be the same values needed from this new page, but would go to Row 5 on the Overview page.