How to make a Equipment Maintenance Database

Hello all, I have been trying to create a equipment maintenance database. What I want to do is have 1 excel sheet under 1 tab for all my Mechanics to send me every week. There is 1 row of each day for 7 days to input the meter reading. The other part has 6 columns. First is the Description (example-Engine Oil). Second column is the Intervals (this tells how often the engine oil is changed (500 hours)). 3rd column is Previous Change Hours (this is what they have sent me in the past) along with the Previous Change Date on the 4th column. Then we have Current Change Hours on the 5th along with Current Change Date on the 6th. The current change hours will also be another thing the mechanics input into the excel sheet. There is one last thing they will input and that would be Major Maintenance Repairs & Comments.

What I want is for all mechanics.. (like 10 of them), send it to me weekly and let it automatically put all these sheets into somewhat of a database or master list.

I want the database to insert meter readings into a report format, send current hours & date to previous hours & date for the updated list I send them in the beginning of the week.

I want all rows of the Item Description and the rest of the columns to be red when the item is pass due on a change.

I have to send out weekly report to managers (probably of the database) of all equipment. The weekly report would have to have all the meter readings of each day and the following maintenance changes made that week. I would then move them to previous after the report would be sent.

I have the template done for the mechanics to use but have no clue how to go about doing this. Please help!!!!!

Thanks,

Kenley