Is this possible?

I have 2 worksheets in an excel file. Sheet 2 updates everyday and is
fed from an input schedule. Every quarter end i would like to copy
that days info into Sheet 1. So for example, all through jan, feb and
march information is being fed into Sheet 2. However, on MARCH 31 I
would like to take the information shown in Sheet 2 and paste that info
into Sheet 1 (pretty much taking a snapshot of that quarters data).
Once April 1st hits, Sheet 2 goes about its business collecting data
thats being fed and Sheet 1 retains the info it took on March 31.

The idea is at the end of every quarter Sheet 1 populates info copied
and pasted from Sheet 2.......

Can anyone help me???

Cheers.