So I wanted to create a dynamic data compilation structure. I have multiple sheets in the book and each sheet contains data of 1 month.
I want to make a compiled sheet of that contains a single cell that is common across all these sheets i.e, I want a compiled list of Portfolio Loss for each month. I want to do it in a manner that if the user creates a new sheet and adds the data of another new month, the Portfolio Loss of the same too is added in the master compiled sheet. I would love your help in the same.