SQL query to pull column data when the header name in T2 matches the headers name in T1.

[Kaia_Strickland]

I have a table on one page with a dropdown list in the header. I want to pull the data from the column in the first table 'T1' when the dropdown in 'T2' matches the column header in 'T1'.