So you have (at least) 2 tables:
Equipment (has columns for EquipmentID or EquipmentName, and RepairStatus);
RepairTracker (has column for EquipmentID or EquipmentName).

Add a sheet with ODBC query, which reads from Equipment table the needed info for RepairTracker table, where RepairStatus in Equipment table is not "Good", and the matching EquipmentID or EquipmentName in RepairTracker is missing.
After the query is refreshed, copy the query data into RepairTracker table.

No you'll have 2 possible ways to continue.
1. After repairs are done, you change RepairStatus in Equipment table to "Good", and delete matching rows from RepairTracker table (you may add a column with formula checking the value of RepairStatus in Equipment table, and use it to filter the rows to delete). This means no history of repairs is stored;
2.You keep the history of repairs. To do this, you need in RepairTracker table a status column registring repairs as done. You have to add an additional condition to query created earlier, to ignore all entries in RepairTracker table where repairs are done too. And after the repairs are done, you change both statuses in Equipments table and in RepairTracker table, and don't delete any records from RepairTracker table.