Dynamic column name based on a column value coming from a different unrelated table

Hi,   I have a requirement to get the column name (for Table A) that can change dynamically based on column value that is coming from a different table (Table B) which is not related to this table ...