I am using the "Filter" formula and would like to make the "reference" to a particular column in a table be dynamic, so that I don't have to have different formulas on different tabs - I can just make the fomrula reference a cell on each individual tab to get the name of the column needed.

The code I am using is as follows:

=FILTER(Table1[FirstName],(Table1[Men]=$A1)*(Table1[Age]=$A2)*(Table1[Weight]="Y"))
In this case, I would like "Weight" to be interchangeable with other options that can be decided on different sheets, so instead of referencing TABLE1[WEIGHT] it would reference TABLE1[A3] where A3 is not a name of a column in Table 1, but rather the value of cell A3 on the worksheet.

I've tried a few variations of the following, but am either messing it up - or completely off base... Im' not sure which ><

=FILTER(Table1[FirstName],(Table1[Men]=$A1)*(Table1[Age]=$A2)*(Table1[&"$A3"&]="Y"))