仅复制可见表格中的单元格并粘贴到下一个自由列VBA中

I have a VBA code that is currently running where it is coping cell (C2: C3) from all sheets and is pasting in the "Master" sheet. The issue that I have is that I want it to only copy the visible sheets as some of my hidden sheets have different data running my sheets. I also have an issue of it pasting in the next row and I want it to paste in the next column and can't figure it out :/.I have a VBA code that is currently running whe