VBA CODE to Copy Paster data from one sheet to other sheet on a daily basis

Hi all,

Could any one please help me.

We used to have a extract data which will change on a daily basis.

But I want to see the trend of the same for a month.

The data looks like

Unit----- period------- Amt

Product will remain unchanged but period and the amount changes on a daily basis
While I want to see the trend .

I want to see the data gets pasted on a daily basis one after the other.

Herewith i have attached the sample sheet where in the before sheet we will extract the data daily which will change on a daily basis .

I want the after sheet to capture the data and paste the data one after the other as it was on the sheet.

hope this helps.

Thanks a lot.