what is the best way to do this ?
Keep all the data in a single table.
Databases are intended to store data. Even more data than you an imagine.
Just add date field tho the table and you’ll be able to filter out your records by month – you just need to learn a little SQL for that.
solved How to: Archive a Database [closed]