best method for automating a process of checking against a master file?

Hi all

just a question around what would be the best course of action to get the below process automated. would it be a Macro/VBN? just after some guidance and to get pointed in the right direction then I can engage with someone to do the work.

Once a week we receive a SOH report which shows product qty's and best before dates which we then have to manually go though by line and see if anything is coming up close to best before date. (small example attached) what I am trying to do is if we have a master workbook (second sheet tab1) with the minimum best before for each product code can something be setup to automatically check all the codes and best before dates and return them in a way that shows things that are within 30, 60 , 90 , 120 days of minimum best before. (example of returned values in second sheet tab2)

this way we can easily run it and see what items are coming up on best before date.

thanks