Index and Match based on expiry dates in multiple sheets

[Mr.Fatcat]

Hi,

New user to this forum, and i´ve really tried to search if this problem has been solved and I cannot find any solution. (There is most likley someone who solved this before but i simple can´t find it) So please re-direct me to the solved thread if there is any.

I've attached the a template book so one could see more easily.

What i´m trying to accomplish in my workbook is and Service Contract List of equipment using multiple sheets with names of cities around. In each sheet there is an expiration date for equipment and hardware. And there will be even more of these sheets later on, but this is a template so all will look alike and have the same column.

On the index page I want to create a index/match function or lookup of all devices that has past its expiration date and will be shown in the Expired columns.

There is a =today() in index B1.

So when i open the book all devices that has expired should be seen on the first index page so it´s easy to see.

If someone can help me it would truly be great!

Thanks,
Anders