Max value in Different Columns

Hi All

i have a table with sales persons and there sales across years from 2001-2030

i have a scroll bar which will give years in 5 columns (This step is a larger part of file i am preparing)

Ask : When i click the scroll bar the year in the columns(G19:L19) change subsequently based on i want to have highest number of sale in that year
in the next row to each column

I tried using max, maxifs, index, match, but i am unable to connect and get the correct result. file attached

Your advise is much appreciated.