Example:

Worksheet Names - Report Card, Labor Hours, Work Orders

On the Labor Hour and Work Order sheet, the data will have many rows
and columns with data like - work order number, type of worker's
trade, labor hours, aging of work orders, etc.

If I am looking at the Report Card worksheet, can I create a button,
drop down, etc. that will automatically pull just the data I want from
the other sheets and populate the approprate cells.

So, if I want to see that avg labor hours and work order aging for
just the electrical group, not the HVAC and plumbers, can I select
electrical on the report card sheet and it will find the data from the
other sheets and populate the cells?