Better option than INDIRECT function?

[RedOctoberKnight]

Good Morning,

I have the following formula that I use to reference data on a specific sheet based on value in E4. (E4 contains the sheet name I'm looking for.)

=IFERROR(INDEX(INDIRECT("'"&E$4&"'!$X4:$X128"),MATCH($B7,INDIRECT("'"&E$4&"'!$Q4:Q128"),0)),"")

I probably have THOUSANDS of cells that use this formula that reference 70 or so sheets of data. My workbook has basically come to a slow crawl when it comes to calculating.

Ive read that using INDIRECT formulas can dramatically slow calculation times so I'm wondering if there is a better way I could do it?

I know a little bit about VBA but I'm basically a self taught excel user.

Any help would be much appreciated.

Thanks!

 

[RedOctoberKnight]

I think i was able to workaround my problem by creating a sheet selection event that turns off and on calculations when sheet is selected. So now sheet containing all the INDIRECT formulas doesnt calculate unless its selected.