You may be able to keep this always current with a vlookup formula.

A VBA suggestion would be to loop through the serial numbers of one sheet
Use match or find on the other sheet
Offset to get the date
Datediff to get the delta.

A better answer could be provided if you actually do attach a sample workbook.