Oops I made it confusing for you again.

Would try to explain.

1. The macro gives us results in Column "Q" of each sheets in ActiveWorkbook that is open in front of me but, I was wondering if rather than giving the results in Column "Q" in each sheets, can the macro provide all these results of Column "Q" in a new Sheet Called "Records". The new sheet "Records" should only have the name of each sheets and their respective results (that is suppose to be in Column "Q" in every sheet).

2. All the workbooks will be in same folder and will be named similarly for e.g. "Book1_Sep 2019", "Book2_Oct 2019", "Book3_Nov 2019"………….. And so on. Every month a new workbook will be added and this new workbook would be our OutputBook where we will run the macro and the previous months Workbook will be the Source. Like For November 2019 the Output book that will be opened in my front will be "Book3_Nov 2019" and "Book2_Oct 2019" will become the source and so on.

3. For coloring the Results if they are More than 3% "Green" and less than(-) 3% "Red", the easiest way is to apply Conditional formatting but, I have to apply the conditional formatting every month on each column "Q" in each sheets (since, each month the output will be in a new workbook) so, I was thinking if a code can make this process easier as well.

Thanks for all the time that you have spent on the code above.



Sumit