We have requirement to generate weekly and monthly trend charts in Excel based on a list from SharePoint. There is no option to capture date in this list. 

We thought of copying data from one list to another list on a weekly basis (and by adding new column to this list as a date of shipping). This would allow us to generate weekly/monthly trend charts. 

Is there a way to copy/automate this data shipping from one list to other by end of week?