There are a few different ways to approach this. If you want to get really detailed, you can create a separate worksheet for each task and then use the VLOOKUP function to populate the cells in the workbook with the appropriate information. However, if you're just looking for a quick and easy way to keep track of tasks, you can simply create a list in one of the worksheets and then use conditional formatting to highlight the cells that correspond to the task at hand.
Assuming you want to go the route of creating a separate worksheet for each task, here's what you need to do:
Once you have all of your tasks listed in one place, you can use conditional formatting to highlight cells based on their content. For example, you could use a rule that highlights all cells in the "Due Date" column that are within 7 days of today's date. This would give you a quick way to see which tasks are coming due soon.