Ensure mandatory fields inputted by the user

Hi folks,

The sample data with the vba code is attached.

I need on click of the button in the "Results" tab, I should get an error if all the mandatory fields (marked with *) are not inputted by A/B/C and get the notification like...all the mandatory fields are not inputted by A or B or C, if 2 will not input...it should be like...all the mandatory fields are not inputted by A and B. These mandatory fields are dynamic in nature.

Hope I am clear with the requirement. I am novice to macros, hence thought of reaching out to experts community.

Thanks in advance...
Abhi