how to copy selected range from sheet 3 to 1
i have one excel file of march 2011 containing 31 sheets named from 1 to 31 as per no. of days each sheet has some data of same day as 1/3/2011 and same data of the same day of 2010 as 2/3/2010 and the same for all 30 sheets now i want to make new file for march 2012 by using this old one so i need to shift the data of 3/3/11 which available in sheet no 3 to the first sheet because this year 1/3/2012 equal 3/3/2011 and copying the same for all sheets for ex. next step from sheet no 4 to sheet no 2 and so on plzzzzzzzzzzzz i need the code, alot thanx 
how to copy selected range from sheet 3 to 1
===

i have one excel file of march 2011 containing 31 sheets named from 1 to 31 as per no. of days each sheet has some data of same day as 1/3/2011 and same data of the same day of 2010 as 2/3/2010 and the same for all 30 sheets now i want to make new file for march 2012 by using this old one so i need to shift the data of 3/3/11 which available in sheet no 3 to the first sheet because this year 1/3/2012 equal 3/3/2011 and copying the same for all sheets for ex. next step from sheet no 4 to sheet no 2 and so on plzzzzzzzzzzzz i need the code, alot thanx 