I've got a weather data workbook but with all the background processes on worksheets that are hidden. It currently only supports 4 cities - NYC for example - each city having it's own worksheet and I need to extend it. When the location is chosen (through a drop down menu), the data is called from the respective sheet and goes on from there. I currently use this formula to look up that cities data:I've got a weather data workbook but with all t