Copying data from Tab1 over to 2 and 3 with individual conditional logic - if possible?

Hey there - I know the general basics of excel and started to brainstorm a solution for a problem we have at work. There is an excel sheet we enter Expiration dates in. If I set up a conditional l...