Instead a single workbook, create for every tech his/her own workbook. And a master workbook for management, where in hidden worksheet data from tech's workbooks are read in using ODBC queries (e.g. into a single table where for every tech a certain number of rows is reserved - like 500 or 1000 rows per tech data).
And then on another worksheet, meant for management, use another ODBC query to consolidate data from hidden sheet into table you want users to see (i.e. all empty rows are filtered out, and only rows you want to show are read in). NB! You can make separate sheet for displaying all machines which are OK, and another one for displaying all machines which are not.

You can go even further. You can have the list of all machines in mangement workbook, where machines can assigned to techs. Techs workbooks use ODBC queries to read the list of machines assigned to this particular tech only into hidden page in his/her workbook. This hidden table is used as source for data validation list in visible table on another sheet, where tech registers assigned computers and fills his/her info (he/she can't enter such info directly into querytable read from management workbook, as there is no guarantee that this info remains linked to right row when query is refreshed). And you have to foresee means for tech's be aware whenever there is a new machine assigned and not added to update table, or when the machine in update table is not assigned anymore.