Track changes in excel 2002

Hopefully someone can help me. I have a user who has an excel spreadsheet that is used for tracking customer orders. He has a macro that clears the data in certain columns at the beginnig of everyday. Just recently he has been asked to have the data that would normally be deleted stored for reference (ie: a customer calling to find out what they had ordered on a specific date). Is there a macro or some other way to get excel to copy this data to another sheet or workbook? Thanks!!