An excellent example why it is better to keep all data with similar structure in single table!

Had you did so (and added a Year column), you could add a filter for year to your pivot, and then you could select any year in your source table you want the pivot for, and you'd get it!