How to cut part of records from A table and paste to B table by action?

I have an attendance app which records every employees’ attendance. I hope this app records attendance by month(there are only current month’s data in the app), therefore, how should I create an automatic action or a workflow to cut records from A table and paste to B table when it comes the end of the month?

May I ask why do you want to use more than one table for your app… like one table for every month? Why don’t you use the same table and just filter it?

Because I hope it displayed by current month is easy understand and simple.

You could still do the same from one table only with suitable filtering formula.