List box activated on opening file
 

I'm would like to set up a listbox so that when a file is opened the user is
asked to select the current period forecast. I have a named range called
"forecasts" which contains the forecast details. Once they have chosen I
would like the value they have selected to go into cell B2 on a worksheet
called "Forecast"
I would then want to move to a sheet called "Opco Sheet by KPI"

Is this possible?