Hi everyone,

Thanks in advanced for any help provided.

Ok so here goes. I have an excel workbook that has 4 tabs. Each tab represents a trimester. The info that I am putting in each tab is the Customer name, an expiration date and the type of product they have. Not all customers have an expiration date though. I have another workbook that is divided into tabbed years (starting with 2016 to 2021). What I want to do (if it is at all possible) is link both workbooks so that I can place a formula/function so that if an expiration date is in 2016, it will place the Customer name, expiration date and product they use in the 2016 tab. If the expiration date falls in 2017, then the info will be placed in the 2017 tab and so on and so forth.

Can anyone help me out with this?

Thanks,

Jace