Hi
I was wondering If you can help me with my problem.

I have 17 files that have 9 sheets each. I have one workbook that has one sheet in it called master.

I want to run a macro from the master sheet that copies range A1-B50 from each sheet in the 17 files and paste them as values one after the other. As this is a master sheet, Next time I run the macro, I want the data to be pasted on the next empty column. so the first time macro is ran, data be pasted in column A and B, second time C and D.......

Please note:
-Not sure if this matters, but sheets are password protected
-every month the location of the folder containing the 17 files changes so it would be great if I can choose the files.

Your help with this is much appreciated and if this works properly, I will save myself hours of work every month.

thanks