Saving information to a listbox from cells in sheet1

Red text shows you the location of the issues I need help for.

What my project already does:

It saves information provided and written by the user from sheet1 to sheet2 with the click of a button. Sheet2 keeps a log of all the records ever made.

What I need to do:

Normally, the information will only be saved to sheet2, but if certain criteria is met, it should also be saved to specific location in sheet1.

This criteria is located in sheet1 as following:

"Is this a note for an upcoming event?" (Cell B15) And below this question is a box with the possibility to mark it.

If this box is marked, it should also be saved to sheet1 location: "upcoming events" in a listbox object when the "save to log" button is pushed.

It would end up in a list of notes.To keep it clear, there should be somekind of way to keep the list organized in a way where the most urgent event would be on top of the list, less urgent below it and so on (this function should be running all the time to keep the list updated when new entries are made). Also outdated entries should be automatically deleted from the list when the date is marked as yesterday or older.

The list doesnt have to be a listbox object, but I dont know is there any other way to make a scrollable list with only cells.

I would really appreciate all the help I'd get for this problem.

I thought this would be simple for someone who knows more than me about Excel, but apparently it isnt?

It doesnt have to be a listbox. I just dont know any other way to make a scrollable list.

Other than that I think my explanation should describe everything just fine.