So yes,
here is the scenario.
First workbook I have to copy  one column.
second three column.
third one line: which has 12 sheets for each month.( i ignore it first to make it simple).

I have to copy paste all that data  in new work book.which will be in the same directory.

2.Yes, new data should be over written. There is no need for previous data.
3. There should be gap for say two rows.
4. There is no intention to manipulate data right now.
5. I don't understand linking data with other workbooks. Actually, I need to automate this process so that even if there is no body  to take care of it, people who need the data will keep recieving this data by outlook mail.