Please Help! Stuck on Formulas for keep station plan up to date

Hi everyone.


I'm a newly registered member. Hope someone 'out there' can help me with this task I'm completely overstrained...
I have 25 Daily tasks in a column, every task comes with 7 values under it, there is a dropdown list on the top of every task (dropdown list Station 1 to 25) .
After choosing the Station for example A6 I would need the following 7 cells include the Station number copied to another place in the same sheet.
I would need this action to create an Floorplan to keep visual on track with the daily progress and positionsSample.xlsxSample.xlsx.


I have tried several formulas, but I cannot make this work.

I would be really grateful for anyones help on this, as I have spent hours and hours on this, and I am just banging my head on the wall!



Many thanks,
Carmen
Sample.xlsx