Archive function

i want to ask how could i create a new table i will call it archive and then have my all of my other tables that have data to move those data based on passing 10 days from creation date so for example my structure is ASN # , event, Created on date 

and lets say i will say that todays date - created on date will give the number of days difference based on that if its more than 10 days ill just have it moved automatically should detect the table by itself this record and push that row of data in my table to the archive table if someone can help with this