Create spreadsheet that pulls weather forecasts

I need to build a spreadsheet or database in excel format that pulls weather forecasts (temperature, precipitation, wind speed) for the upcoming 0-6 hrs for a number of cities in the US (cities needed are in attached spreadsheet). Specifically, I need temperature, precipitation and wind speed and I need them to update/refresh automatically.