write a macro for variable cells
 

I have data collected on a daily basis and summed into a total column for a
single week - say week 10. I then need to copy this data into a specific set
of cells in another workbook for that week which is headed week 10. The
original week 10 data is then deleted and new data for week 11 is entered.
The second workbook has individual columns set up for weeks 1 thro' 52 and I
need to retain the data so that I can graph it throuh a 13 week period. Can
anyone help with a simple macro that collects the data, pastes it into the
relevant cells and then deleted the original data? Many thanks in advance to
all who take up the challenge.