VBA Code to check if entry exists in a range for each date in a date range

I need VBA code to check if entry exists in a range for a value against each weekday in a date range

If the value to be searched is in C4 and the date range is in B7 & B9 of workbook A, It should check the range A:E in 'Tracker' worksheet in workbook B (in which the value being searched is in column A and individual dates are in column E), if any of the weekday values in the date range exists in the range A:E then it should return a msgbox.

i.e. if the value in C4 is X and the date range in B7 & B9 is 3/1/2022 & 3/10/2022 it should all 'X' entries in the column A of the range A:E in workbook B and check if corresponding entries for each weekday exists in column E, if it finds even one match it should return a msgbox and exit sub

I've attached samples of the workbooks.