I have a dashboard in my reports that I refer to a lot during my work. It has one sheet with data, where i can use filter at the top choosing the Asia region, then countries and then month.

Now, I am using a very long process to get values out of the sheet. I insert a new tab and give cell references, so I choose "Malaysia" in the filters and the cell references are in the new tab. I then copy the values from the tab and paste them as numbers in a new sheet. I then keep changing the filters for country and keep copy pasting the cells in the new sheet one below the other. I am sure there must be another way to do it. Can anyone refer me to a thread where this has been discussed or tell me what I can do.