Copying and Pasting between Workbooks VBA
<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>