Excel Formula

Yes indeed; more information would be helpful. It's probably not a difficult thing to resolve, but seeing the actual workbook (or a fully representative mockup, if the actual contains confidential info) would make it a lot easier to help you.

That said, assuming that there probably are multiple "Thursday" entries on Sheet 1, and multiple corresponding dates, you might find the FILTER function does what you want. If you're comfortable playing with new functions, have at it yourself. That hyperlink provides some good examples. You might also find one of these YouTube videos to be useful.

But if help is still needed, come back and post a sample of your workbook, not an image, an actual Excel file.