[VBA]
Dim objNS As NameSpace
Dim objInbox As MAPIFolder
Dim objMyFolder As MAPIFolder
Dim objItem As MailItem


Set objNS = objOL.GetNamespace("MAPI")

' find the correct folder
Set objInbox = objNS.GetDefaultFolder(olFolderInbox)
Set objMyFolder = objInbox.Folders("Business Management")
Set objMyFolder = objMyFolder.Folders("MI")

For Each objItem In objMyFolder.Items
With objItem
' was the email sent today?
If Format(.SentOn, "yyyymmdd") = Format(Date, "yyyymmdd") Then
' test the subject line
' you have not indicated what you want to have happen in Excel, or provided
' a sample workbook, so this just displays a message
Select Case .Subject
Case "1st Test Subject"
MsgBox .Subject & "Sent " & Format(.ReceivedTime, "hh:mm")

Case "2nd Test Subject"
MsgBox .Subject & "Sent " & Format(.ReceivedTime, "hh:mm")

Case "3rd Test Subject"
MsgBox .Subject & "Sent " & Format(.ReceivedTime, "hh:mm")

Case "4th Test Subject"
MsgBox .Subject & "Sent " & Format(.ReceivedTime, "hh:mm")
End Select
End If
End With
Next objItem
[/VBA]

The code above will loop through the folder looking for the specific email subjects (obviously you will need to enter the correct subject lines in the code). This is just a slight variation of the code I sent you earlier - did you try this at all? You could have run a test on this code simply by adding a message box.

In terms of a trigger, you need to specify what you want. There is no point having it start when you open the dashboard if the dashboard is open all day. Otherwise you will have to keep closing and reopening the dashboard file to trigger the macro.

I suggest you add a button either to the toolbar or directly on a sheet. You can call the procedure whatever you like, and then associate it with the button.

Sorry but I simply don't have the time. That's why I've been looking up all these forums (fora?!)
Keep in mind that people who respond to questions are volunteering their time. If you want to get responses you have to demonstrate a willingness to try and work things out for yourself. I (and many others on this forum) charge our clients to perform this kind of work - we're not here to write your code for you for free, but to help with specific issues as you attempt to write your own code.