I think your workbook has backwards design! You enter data on various different sheets, and then want to consolidate them on single sheet. Instead this, consider entering data on single sheet, and having report sheet(s) where you can get data for any designed selection. Attached is an example based on your data (it is an example only - really you can have any report designed in any way you need for which your data entry table has data available).

You can hide columns with brown-colored headers (helper columns), as users don't need to see them at all, and they mustn't have a possibility to edit them.