Why not use a parameter to achieve this? I've added a parameter for the year, and also two boolean fields to each of your workbooks to filter just to the year selected in the parameter control.
Another option is to do it with actions - a separate sheet to have just a list of the years to serve as a filter control, and then use the actions to do the filtering.
Attached are the examples, which I hope will help a little!
Thank you so much for your help. Sorry I took so long to reply. Both suggestions were great, but the one that worked the best for what we were trying to achieve was the second option, the one with the actions.
Thanks again for your help!