Thank you for doing this!
Hmm this seems to be only picking up the latest record in the first sheet? When I then add another one for company A in the other later sheets it doesn't update it. I want it to be able to pick up the most recent record for that company name within the whole workbook essentially.