Dragging combobox to other columns with relevant LinkCell

Hello, I am not very advanced with Comboboxes, I am learning it. We need the search function within the dropbox and bigger font so I am switching my data validation lists to comboboxes now but I cannot find the answer to my question yet.
I have a ComboBox in cell C2. I attached it to a cell from its settings, it is not floating. Whatever is selected from this list has a LinkCell to its own cell C2.
So when I use design mode, I am able to drag this cell to the right to the other columns. This creates new comboboxes in Column D, E... etc as I want but LinkCell of these ones always remain as C2. I want them to change and adapt as D2, E2... etc.
How can I do that?
I don't really want to manually create it because the columns go till AA and I have many cells I need to apply the same.
I am not able to upload the sample file here unfortunately I am sorry about that. I appreciate any help.

You could load a sample file that illustrates the layout of your worksheet.

The linked cell will not automatically update just by moving the control. You will need to change it.
Or you could use VBA

Please Login or Register  to view this content.

Hello Andy, thanks for your reply. I will use this VBA and see. I am sorry I couldn't upload a sample file for technical reasons. The file is in my work laptop with sensitive data and I am posting this from my phone.
I will try the VBA you posted, thanks a mill.
I also applied another VBA that sort of worked. I want to share it here.
I went back to the main reason why I wanted comboboxes and it was mainly because usual data validation dropdowns were too tiny to read for my team and the nice search function. So I looked up and found another VBA on internet and applied it. It sort of worked and replaced all my usual dropdowns with hidden comboboxes. The only problem with this is once you make a selection from one hidden combobox, whereever else you click with a hidden combobox, it shows you the last thing you selected from the first combobox at first. It is a bit weird but I guess it is not too bad.
I will paste the code I found elsewhere online, posted by a very helpful user called Skyyang - I hope it is not against site policy to share it here in case anyone else is looking for solutions for this issue.

First you place 1 combobox with list range in the worksheet that is full of other data validation lists. Then apply the following VBA code into the sheet module code. Right clicking on the sheet and applying it to its code worked for me.

Please Login or Register  to view this content.

After inserting the code, now when you click the drop down list cell, a combo box will be displayed, and font size in the drop down menu is increased as I needed. And the inserted combo box is hidden automatically.

I only increased the width of the box and changed it to 200. Thank you for checking my post and helping with this issue.