Why do this?

Can't you just have a single sheet with a column for Paid/Unpaid, then filter for Paid or Unpaid as required?

This would be much easier to maintain and far less error prone.