Is it possible to use the contents of a cell in Excel as the criteria of a
field in an Access Query? I want to use Excel as an interface and reporting
tool for a data table stored in Access.

For example, in this theoretical interface, I would like to:

On a "parameters" Excel sheet, type a client name in a specific cell

On a "data" Excel sheet, refresh an external data range that is an Access
query that calculates typical metrics for only that specific client name

On a "report" Excel sheet, format the returned data in a presentable way

The major problem that I am having is that I do not know what needs to be
typed in the criteria of a Access query field so that it filters on the text
of a specific Excel cell.

Any help would be greatly appreciated,