This title is bugged.
1. On the lodestone company page it states that anyone making it to the "Yesterday's Heroes or the Last Week's heroes" would be bestowed this title.
2. Title only bestowed upon "Last Weeks Heroes"

The reason this is a problem is because it states

* Those players whose names are displayed under “Last Week’s Heroes” and “Yesterday’s Heroes” will not have their names appear in consecutive lists, regardless of total company seals accumulated, in order to better recognize the efforts of a wider range of individuals

Meaning that you will never get the title unless you make it onto the weekly list, so if you make it to "Yesterday's Hero's" you miss out.