It might not be the most ideal way, but I have cracked half the challenge by creating an identical table (history) with an Append step to add the rows from the table (staging) with the main query. Now when I edit the staging table query to just get the data from the date it was last run (manually entered), it them adds result to the history table.

Next step would be to figure out if there is a way to automatically update the date to the last time it was run.