Time Based Activity

Hello all,

Please I need assistance to develop an excel sheet, probably with macro, that does the below.
1. Has a list of components that are to be replaced on time based on rows
2. Has dates on the column
3. In every cell, I want to be able to "mark" whenever I carry out a replacement on the date it is due
4. Based on frequency defined, I want it to show in advance next due date
5. I want it excel to trigger a list of components due for replacement a day before and send as mail
6. To show different colours on dates depending on whether the replacement is due and has not been done or has been done.
7. It automatically generates new sheets for every month task.


Perhaps someone must have used or designed this before.

Thanks