Selected Answer
Yes, I'm sure there must be several ways of doing what you describe but they are all wrong because they go against the essence of what Exel does, should do and can do.
- In Excel you have one list of data, only one! The requirement is that it must be easy and efficient to add data to this list.
- Then you have the option of displaying these data in different ways. For this purpose you can use filters or pivot tables or even VBA.
Therefore you shouldn't have two sheets. You should only have one sheet with all the jobs on them. There should be a column (or two) to mark the due and paid ones. The information you expect from your second sheet should be in a list which you prepare from the first any time you want - using filters, a pivot table or VBA. The list (and more lists if you need them) would be available just as quick as you now switch from one sheet to the other but they wouldn't exist permanently, meaning you don't have to maintain or update them.
Meaning, precisely the problem which your question is about would never even exist.