Power Query Tables Reading Each Other's Tables

[dannie]

I am very new to using Tables and Queries. Basically I'd like whenever I add a line of data in one table, to have it added to the Power Query Table on another sheet. The other sheet will still have data on it, so the newest data I would like to add it, not replace it.

I want to also have the tables appending each other. Pending table reading from PPR table and Approved table, as well as Approved table reading from PPR table and Pending table, and so on with other tables.

INFO:
-Lines from original data table (PPR Table) will move to new/appropriate table based on their Status
-Status can changes once on another table (ex: pending can be approved and then go back to pending status). I need to be able to have these move to their correct tables.
-I don't want what is already on the Table to be deleted, just adding lines until the Status has changed

Here is the part of the Advanced Editor on the PENDING table:
let
Source = Excel.CurrentWorkbook(){[Name="PPR"]}[Content],
#"Appended Query" = Table.Combine({Source, PPR, APPROVED}),

Any help or guidance is appreciated, thank you.

-dannie