I would like to paste multiple data in a certain column on another sheet

for example on my main sheet i have cells which contain numbers, i would
like to select a week number eg. 430 (dont ask) and then paste all info into
the correct column for the graphs, in this case the 430 column

i think it can be done with combo box to select the week number but then im
stuck.

thanks