Index and Match based on expiry dates in multiple sheets

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

Hi,

Thanks for that VBA!

Somehow I only see one of the expired contracts 3 times, not 3 different devices. Can that be added?
Also, what to I need to add to change the view back to the index page after I run the command?

Regards
Anders

Amazing! Work excellent.

Last thing, is there a way that we can add the ones that are on itīs way to be expired, say within 6 months it will show in Index G14?

Regards
Anders

Hat off to you!

Many thanks for your help!