A formula that changes the sheet reference based on cell value with sheet name

liz123395 

You are correct that excessive use of the INDIRECT function, especially in large quantities across multiple formulas, can potentially slow down the performance of your Excel workbook. The INDIRECT function is known for its volatility, which means it recalculates every time any change is made in the workbook, even if the change does not affect the referenced cells directly. This can lead to increased calculation times and slower workbook performance, particularly in large and complex workbooks.

In your case, if you have 35 tables and each table contains multiple INDIRECT formulas referencing different cells on different sheets, it could potentially impact the performance, especially if your workbook is already large or contains a lot of other formulas and data.

To mitigate this, you may consider alternative approaches such as using named ranges or structured references instead of relying heavily on INDIRECT. Named ranges can provide a more efficient and structured way to reference cells and ranges across multiple sheets without the volatility of INDIRECT. Additionally, restructuring your workbook to minimize the number of cross-sheet references and optimizing your formulas for efficiency can help improve performance.

If you find that your workbook's performance is significantly affected by the use of INDIRECT or other volatile functions, you may need to consider redesigning your formulas or workbook structure to minimize their usage and optimize performance.