I have 50 workbook files. One workbook is a master report that is made from the 50 workbooks. I have to cut and paste the data from each workbook into the master workbook. I am in the process of automating the workbook to simplfy the process. I have reviewed several of the post here and have not seen a solution to my problem. Is there a way to automatically (marco,code) append the data from the 50 workbooks into the master workbook?
Also I have attached a file representing what I need in a picture view.