title: Copying and Pasting between Workbooks VBA
body: <p>Please bear with me I am still learning VBA and could do with a little help.</p>
  
  <p>I am trying to copy data from one workbook to another even though there I have found many answers on this I am unable to
  Understand the code as its quite complicated. I was hoping if someone could help me with a basic code which is pretty easy to read and understand. </p>
  
  <p>I am currently looking to copy all data off 3 different workbooks  and paste it into 1 workbook across 3 worksheets.</p>
  
  <p>For example I have 3 workbooks called</p>
  
  <p>AA
  BB
  CC</p>
  
  <p>I want to copy all the data (value only) from these workbooks and paste then into workbook called</p>
  
  <p>Main</p>
  
  <p>But I want that data from AA.to go into Main Worksheet1 and
  But I want that data from BB to go into Main Worksheet2 and
  But I want that data from CC to go into Main Worksheet3</p>
  
  <p>I hope I have explained this question properly and I appreciate any help.</p>