So, the macro is assigned to a button and when this button is clocked, data from E4, C7, C8, C11, D11 should be taken, the first cell of the output should be set to "=ROW()" so we can obtain the row number. The second should be D11, the third should be C11, the fourth should output the key command of CTRL+SHIFT+;, the fifth should be the keyboard shortcut of CTRL+; the sixth should be C7 and the last one should be D8. I've tried multiple things that did not work and I bet the solution is really obvious but I can't see it for the life of me.

Thanks in advance!