Data Alignment using macro

Hi Gurus,

Anyone need a favour to me regrading my query, herewith I have attached one excel sheet in the name of Daily report, in this report day to day we paste the data (fetch the open tickets cases in other sources, like BO).so my question is the data for open tickets differ on day to day basis both LAN WAN open and Legacy open so instead adjusting the (insert, delete, rows) need a macro will copy paste the data from Open cases to daily report sheet.
So could you please guide me how can I write a macro example here the open count for LANWAN open is 34 but in the daily report sheet shows the only 27 (count it was previous day count) now the count will automatically change kindly help.

Thanks
Raju