I am working in a excel file with multiple sheets. There I have a top sheet & a dashboard. Through macro & advance filter I set up other sheets so tha

[Syeed Ul Haque]

I am working on an Excel file with multiple sheets. There I have a top sheet & a dashboard in two individual sheets in the same file. Through macro & advanced filters I set up other sheets so that If I input the data in the Top sheet it will update automatically in other sheets. It works fine. But in Dashboard the data is not compiling just after input. It takes the data if I click individual sheets then. What is the possible solution to this problem?