Automatically fill summary table with filtered data based on drop-down list

Hi All,

I have the below excel spreadsheet, where I have a table, with the months on one side and the number of items sold per item in columns.

Item T Shirts Leg Shorts Vest
Jan-20 37 33 34 35
Feb-20 38 33 29 37
Mar-20 41 35 33 35
Apr-20 43 36 33 36
May-20 31 35 43 38
Jun-20 31 38 43 35
Jul-20 44 39 44 37
Aug-20 36 33 31 36
Sep-20 38 33 31 35
Oct-20 38 33 31 38
Nov-20 39 34 44 39
Dec-20 42 36 30 38
Jan-21 27 40 32 40
Feb-21 36 41 37 38
Mar-21 34 38 27 40
Apr-21 42 36 36 41
May-21 42 36 34 38
Jun-21 42 35 32 38


What I want to do is at the bottom, have a drop down list where I select the item, for example shorts, and the numbers for each month are automatically pulled into this table for each month.

Item Sold Shorts (this is a drop down)
Jan-20 answer to automatically generate when a drop down item is selected, so 34 in this case
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21

How would I go about doing this please?

Thank you.