This is a suggested approach and, as such, is untested.

It also assumes that the layout of each sheet is the same.

Having copied all the worksheets into one workbook, each with its own set of unit costs, make an extra copy of one of the sheets and rename it as "Unit Costs". Delete the contents of the other cells but don't delete columns or rows (at this stage)

Then change the Unit Costs (table entries) to refer to the same cells on the Unit Costs worksheet.

Having set up the references on one of your original sheets, copy the table to each of the other sheets.

Once all the sheets refer to the new table on the Unit Costs worksheet, you can delete rows and columns on the Unit Costs sheet to "tidy it up".

It's dirty but relatively quick. Ideally, you'd change any formulae on the original sheets to refer directly to the new table on the Unit Costs worksheet but that could be a lot of work. Having said that, it could just be a case of changing one formula and autofilling down. Difficult to say without seeing the sheets.

Regards