Excel Macro or VB Programming to Create Summary of Data

[PetrusA]

Good Morning,

I have a spreadsheet with a number of tabs which is route numbers for buses. A number of the routes passes the same check points / bus stops. I would like to have the spreadsheet summarized in a format where I could be standing at any of the bus stops and know which vehicle type will be at the specific stop at what time.


The test time tables are uploaded. I could only upload 3 routes, there is about 25.

Thank you very much, i hope someone will be able to assist!