Welcome to the Airtable community!
It looks like your stakeholders are used to working with spreadsheets. Is it possible to structure your data differently, and then present the data to your stakeholders I. The format they way by using the pivot table extension?
And no, you cannot dynamically evaluate the name of a field. You can hardcode the name of a field and process that string in the formula, but I don’t think that is what you want.