Is there a way to just reference the cell
Cells are for spreadsheets. Controls are for forms. I'm not sure but I think you mean to ask if you can reference a form control. Yes, but there's no need to make it complicated. I don't know what you mean by "I would like to to pull a report, form o query..."
If you want to display calculated controls in a report, the report can handle that nicely - no fancy form or query stuff needed. If you'd rather see the calculation in a query and base a report on that, create a Totals query to calculate a percentage by Grouping By on a field such as Dept. More than one grouping is possible, but sometimes negatively affects the desired outcome.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.