Referencing data over different tabs

[piggylumps]

This is going to sound more complicated than it probably is.

I have a number of different logistics routes and schedules spread over their own tabs. I am looking to have one "Loading" tab where you enter the destination location from a drop down list and enter a load date and the following will be automatically populated from the individual routing tabs, probably via a vlookup or something similar:

Load Day
Delivery Day
Delivery Date
Rail Day
Ship Day

How can I get the drop down list to refence the correct tab to bring back the above info?

 

[piggylumps]

Would a data validation be a way forward?

 

[jfish1288]

From what you posted it seems like data validation is the way to go for your drop down list. Then in your day cells you can use a vlookup based on the drop down selection.

 

[piggylumps]

I've never actually used a data validation before and have next to no clue how to get it to reference the route tabs. Any ideas?