Copy rows in seperate worksheets to new worksheet based on date

[irBONES]

Hi, I've got a spreadsheet with 21 active worksheets. 1 of those is a home page and the other 20 all have data on regarding deliveries for my company. I want to make it so that Excel automatically searches for any deliveries >=TODAY on all the worksheets and copies those rows onto a new sheet. I'd like it to retain the conditional formatting that is present on those cells. I'd like this new sheet to update automatically so that once delivery has taken place the cell removes itself from the sheet and when new data is put in with regards to deliveries due, it automatically updates the "All Deliveries Due" sheet.

The date is in column D on the tables and are the second column of each table. I'd like to start the copy of the rows in column C so that all the dates sit back in column D once copied over.

I've been looking this up for a few days and it seems the best/(only?) way to do this would be with VBA but it seems to me these are macros and therefore would have to be run and wouldn't be 'automatic' as such. I have absolutely no knowledge of VBA so don't feel like you're offending me if you give me the really basic information that you may think everyone should know.

TL:DR, my home page is my first worksheet and the following sheets are the different jobs we have. I need Excel to search the data in the tables on the sheets regarding each job and copy the rows where the delivery day is still outstanding and hasn't been yet onto a new sheet titled "All Deliveries Due".

 

[HighAndWilder]

Why do you not combine all of the worksheets into one worksheet and use filtering to display a list of 'All Deliveries Due' for example?

Having all data relating to an order in one row on the same sheet may mean that you don't have to do what you are trying to do.

This may be a lot easier in the long term.