spreadsheet - How to get an excerpt of a table in Excel in a different table? -

I have found an Excel document that is used as a patient database for practice, of their first appointment in the first table There is a complete list of all patients with date and date of their last appointment (if applicable).

In the second table, I want to get a list of all the current patients (no final appointment) in the third table, I want to get a list of all the patients who are (final appointment)

< P> Is there any way to remove these sub-tables from the main table?

What about filters by first appointment or last appointment? ... if you do not care only with one table ...