Copying summary analysis across multiple worksheets to specific locations in another file

[cheal2]

Hi,

I have a master data sheet that I'm using to store analysis from several years of data across a couple of different data types and by branch.

I have monthly file to clean data and ensure properly assignment across type and branch. The output from the monthly file is then put into another file for yearly analysis, which is where the master data sheet is to get its data. I would like to save some time on transferring all of this data around by creating a macro that will change the selections in my yearly data file so I can get the analysis associated to it to store in my master data sheet.

I've attached simplified samples of the yearly and master sheets. I would be okay with having both files open in order to run the macro. They are separate files due to data and usage considerations.

Thanks.

[cheal2]

Sorry forgot to attach the files.