Excel Template
 

I am trying to create a spreadsheet where the First tab will have the
annual data by month. Column A/Row 2-etc will be the description
"product A, Product B, ...etc". Row 1 Column B-etc will be "Jan, Feb,
Mar,....etc" Tab two will have the product description in Column A
and column B will have the monthly data. My question is if I
include a Monthly dropdown list in Tab Two, and select March, all of
March data will appear in tab two. And if I select November from the
drop down list, it will display all of Novembers data?