Need a VBA lookup table from a massive database

So in essence what I'm trying to do, is to make an excel sheet that will act as a welcome page to my database, displaying important data from the DB.
Its a huge amount of information about business orders with different specifics and dates of the said orders are stored in a separate column.
Now what I want to do is to make a table on the first page that would return values based on today's date - 3 (Essentially vlookup that would return multiple values)

Also, I would like for this excel to be able to move rows based on the date value or maybe some separate column with a yes/no that would basically archive the rows in another sheet.

Apologies if this has been posted/resolved before and would love a link to the solution, as I've been perusing this amazing forum for a while and found close workarounds but nothing that I could actually use to resolve this.
Thank you in advance for any help you can provide!

Oh and while I'm at it, is it possible to make a drop-down list with data validation or otherwise that would pull links from the reference into the cell. Or maybe set a certain cell value to be always shown as a link?

Muchas gracias!

If need be ill post my current progress but since it looks like a potato and has NDA'd data i wouldn't.

Here is the sample book, Excuse the formatting

This is incredible. I was looking for a solution in VBA due to the clunkiness of the formula combinations but this will just work fine.
Thanks a lot again.