Move/append to other file/sheets macro

[mightyg]

Hi If anyone please help.

I have two sheets

1. One is source and other is master.
2.Master sheet have 10 sheets and source have 7 sheets.
3.Source file with 7 sheets are updated monthly and need to be pasted to master sheets(same name 7 sheets on master ).
4. While pasting data from source to master, data on each sheet should be pasted without headers and in the end of the master sheet.(e.g master sheet have 10 rows then paste should be from a11)

I've uploaded the sample xcel files.

Can any one please help me to write the code

Thanks.

 

[bobhc]

You have posted the same question on another forum, there is nothing wrong in doing this but it is common manners to tell ALL forums that you are posting on multi forums.
Tthe main reason for this is to stop forum members wasting their time in trying to help you when an answer may have been published else where.

 

[Nebu]

Hi:

This is a common question asked , please use the search box here or use google you will get ready made codes.

Thanks