Race Results and Year Standings

I am looking to not have to sort and consolidate for each race....

So the riders are on the "Rows" and each has a number for each series.

The races are on the columns.

I would like to create a new tab for each race, copy results and points for that race there and have the main sheet "2019 KOI PM Bikes" search that tab.....

So my thoughts are I create a new tab for the race in Column AV. I would like to paste a formula in every cell in AV to look up the riders number (Column D for this series) and return with his points for that race.