Need drop down for tables

How can I get a drop down for the tables going by year?

Please see attached.

Thank you!

Not sure I follow. You just need a dropdown showing years to select from?

If so, create a list in consecutive cells of the years to include, then from Data, select Validation, then select List from the allow menu, and in the source field enter the range where you entered the list of years

Still not quite sure... but here is my best guess.

I am assuming you want a drop down, where you can select a year, and the appropriate table displays separately. Yes?

If so, then see attached.

I created a list of years in V2:V5.

Then in K2, I created the data validation, so you can select the year.

Then in L2 add formula:

=INDEX($A$3:$C$17,MATCH($K$2,$A$3:$A$17,0)+ROW($K$2:$K2)-2,COLUMNS($K$2:L$2))

copied to M2.

In K3 add formula:

=INDEX($A$3:$C$17,MATCH($K$2,$A$3:$A$17,0)+ROWS($K$2:$K2),COLUMNS($K$2:K$2))

copied across the table and down.

Then formatted table as per originals.

You can cut and paste this table to sheet2, if desired.