Populating different tabs from a master tab

Good evening everyone,

I will try to explain what I am trying to accomplish. Not sure if this is a VBA function or if using a formula would work better. I appreciate the help.

- Using the master tab in the attached file, I would like to export, copy, or transfer the data in the reval due (column I in red) column to the specific tab (year tab(s).
- If it's easier to copy the whole row to the year tab that fine.
- The information I really wanted to copy to the year tab was: ID, Name, Reval Due, Name of PM and Lead.

- As new data is entered in the Master Tab, how do you make the refresh button populate the year tabs?

I figured I would add my working file to avoid any confusion or having to annoy anyone asking for help. I just don't understand excel sometimes. I do appreciate the help!