SELECT UNION from multiple tables with same schema in MySQL
Yes, there is a less redundant/verbose way -- PARTITION a single table by year.  Then a single SELECT will do the job.

But, that may not even be wise.  What queries benefit from your splitting it into multiple tables?