Specific Value across multiple tables

Hello,  I am looking to get a specific number from a set of different tables that have been joined in relationships, for example I am looking to get for the month of January the most recent year for...