the second tab should be a list of companies, linked to all records in table1.
I would created it as - make linked field in table1 (to some empty table2), then copypaste whole Company name column into it. In table 2, you receivel unique list of companies, with linked field containing all links to records in table1.
to get “Most recent” field, you should create Rollup in field 2 with formula.
then, if it works in table 2, you may just add it as lookup field to the table 1