Copy and past from different sheets based on different criteria then sum certain columns

For some reason I messed up with the formula, it dit work well, thank you so much.

One last question, is there any idea as to put an alert, highlight on red or do something in Column D from sheet2 when a requested quantity from sheet2 cannot be covered by sheet2 column D?

Attach in red what I am taking about.

Thanks again.