Hi I have been receiving some help however I am stuck with an issue of creating multiple workbook outputs from a master file in a different views. I have attached a sample workbook. I have been working on a code but it keeps erroring out and I cannot figure out why. it is included in this workbook. I would like to have a sample out put 1 and another output that is a subset of the output 1. Also i need to update data between workbooks since each inside sales will have to enter data then consolidate in the master. This data needs to by dynamic so a macro would be ideal.

The final output- outputMasterSEtupTest1.xlsm2 needs to be save as a csv file in the same location of the master. I cannot go pass the first output 1 file to do the rest. If some one has worked on something similar please could you take a look of what i have done and give me some guidance to do this.

I have scrub the data so it has test data.