how to use VBA to copy paste in a determinate cell, changing the variable every week (not in the code) : I receive a weekly table and I've to update various columns in the whole document.

Every week has a target number from 1 to 52.

I tried to make the VBA copy paste in the next free column, but I realized that It can lead you to an error if you don't update it in the proper way.

So I was thinking, do you know a vba code that allows me to decide in the Excel sheet, where the Macro has to copy?
Like I choose the right weekly number in the excel sheet and then run the macro to make it copy in the rightful column in every designated sheet.

Thanks!