How to Create a Rolling Summary Page that Automatically Updates from a Data Table

I currently have a file with a large table which commodity prices are added to on a daily basis. The data from this sheet is then pulled onto a summary sheet that displays the most current three day's prices.

Currently I do not have a formula, so I go to the summary sheet everyday, delete the row at the top of the summary, insert a row below the last entry, and then pull down the last entry to display the current day. I have to do this to multiple rows everyday, and it often results in errors when others have to do it.

Is there a formula that I can use that will allow excel to do this for me? I have attached an example file that further illustrates what I mean.

Thanks a lot to anyone who can help me out!

Yes, the 25, 26, and 27th. And then later today I will enter in data for the 28th, so I need it to update to show the 26, 27, and 28th. Sorry about that!

Close, but when I enter data into the row for the 28th the Summary sheet doesn't update. Nothing happens if I were to add more days either... 29th, 30th

Is there any way this can be done without the =TODAY function? Because I'm worried that if I open this on a day that isn't actually today, it will change everything on the summary sheet. Also, only Bank Trade days are shown in my data, so when a formula counts back from today, and gets to a weekend (which isn't included in the data), won't that mess things up? For example, on Monday it should show Monday 1st, Friday 28th, and Thursday 27th. Won't a count back from the =TODAY function mess this up?

That should work great for what I'm doing. Thanks a lot!