How to create a dashboard with upcoming and overdue actions

Hi,

sorry for my second post in a week seeking help, I am creating a worksheet which will show different elements of a project I am working on. Each project element will have a number of tasks with a due date and a start date. As these are across a number of sheets I would like to create a dashboard front sheet which provides 2 different information boxes, one of which provides a list of upcoming actions including what the task is, what the due date is and who is the task owner.

The other box I would like to create would show the same information but for overdue task.

The tasks are already RAG'ed but I have no idea how to start creating a dashboard front sheet that could show this information.

Would it be possible to show the information up to 8 weeks in advance?

I have included a blank copy of my worksheet.

Hopefully someone out there can help, if its possible that is. I have searched the internet high and low but I am not sure I am using the right terminology to find a guide.

Oh, one more thing I have created a sheet that is automatically populated when a completion date is input, but this always stops working when I try and change the style of the table to say "light 9" is there any way round this as I would like to make it look more professional but without losing that function.

Thanks again in advance!