title: How to move to next blank cell?
body: <p>I have data on multiple sheets in a workbook that I want copied all to one sheet in that same workbook. When I run the macro, I would like it to start by deleting the current data in the "iPage Data Export" sheet and then replacing it with data from the other sheets. </p>
  
  <p>I want the process to occur one column at a time since I may not bring over everything. Right now I am trying to learn how to do just one column.</p>
  
  <p>I was able to get it to copy all of the contents of a column from one sheet, but when it moves to the next sheet, it overwrites the existing data. In the end, I only get one sheets worth of data copied.</p>
  
  <p>Here are my 4 problems:                  </p>
  
  <ol>
  <li><p>How do I make it clear the data on this sheet before running the routine? </p></li>
  <li><p>How can I make it start each copy function at the bottom of that row (i.e. after the last cell with a value)? I have tried many of the suggestions on this and other boards without success. I will admit I am not very experienced in this.  </p></li>
  <li><p>How can I make it copy to a particular column (currently it just seems to default to A.</p></li>
  <li><p>How can I concatenate multiple columns during the paste function? I.e. what if I want it to insert: A2&amp;", "B2     instead of just    A2</p></li>
  </ol>
  
  <p><pre>Sub CombineData()</p>
  
  <code>    Dim Sht As Worksheet
  
      For Each Sht In ActiveWorkbook.Worksheets
          If Sht.Name &lt;&gt; "iPage Data Export" Then
              Sht.Select
              Range("C:C").Copy
              Sheets("iPage Data Export").Select
              ActiveSheet.Paste
          Else
          End If
      Next Sht
  
  End Sub
  </code></pre>