I am using combo box to switch between worksheet. However, the data across sheets loading is very slow and sometimes does not work at all. I am using indirect function in the main worksheet.
Anyone knows how to improve it?

Thank you very much.