Move specific row and colums to another worksheet

logo.jpg

Hi everyone, I have been following this website for a while and it solved many of my excel issues. Right now, I started to got involved with Excel Macro. I am just a beginner for excel macro and most of the stuff is pretty complicated at the moment. I started to create some surveys on excel. However, I want to store the entities in another worksheet. Is there anyway to assign specific rows and columns to another worksheet? (Even though they are merged!!!!) When the participant enters data, it will store it in another worksheet. It will simply transfer the data another worksheet. The complicated part is that most of the columns and rows are merged.

Similar Code I was trying to use

Sub move_worksheet()

RowCount=Sheet1.UsedRange.Rows.Count
Range("a1:" & "a2" & RowCount).Select
Range("a1:" & "a2" & RowCount).Select

RowCount=Sheet2.UsedRange.Rows.Count
Range("a1:" & "a2" & RowCount).Select
Range("a1:" & "a2" & RowCount).Select

With Selection
.Copy
Ebd With
Sheets("Sheet3").Select
Range("a2").Select

ActiveCell.PasteSpecial (xlPasteAll)
End Sub

However, it does not work

I just wonder if this process is possible because the data comes from merged rows and columns. However, I plan to use this code for 19 worksheet and cobine all the data in one worksheet.

If it is possible and someone can provide a sample, I can finish the rest.
Thanks a lot