Hi everyone. New day new challange.

I am looking for a way using Excel VBA wherein I Need to copy cell values from column M from (Sheet3,Sheet4,Sheet5,Sheet6,Sheet7) to use them in a formula in Sheet 1. Now this is simple but the trick part is, the column M in all those Sheets is dynamic and number of rows Keep changing everytime a new Report is generated by the user. The formula column in sheets 1 that Needs to be generated using column M values from other Sheets is also dynamic and the number of rows in this column dynamically changes corresponding to the number of rows in column M .

Thanks