Update table 2 after modified data in Table 1

Update table 2 after modified data in Table 1

Hi,
 
I have a Table, which I manually refresh currently (until I can get the API's sorted).
 
I would like to be able to record when the table was modified, and the total number of rows, in order to compare once I've refreshed it.
 
Is it possible to create a second table with two columns (date modified, and count of rows in Table 1) - which automatically updates upon the refresh of Table 1?
 
I need to be able to use the comparison widget on the Dashboard, to show whether the number of rows has increased, or decreased as a result of the data refresh.
 
Thank you