Hi,

I have a workbook that has a 'front sheet' that pulls information from each of the 150+ worksheets, this uses multiple formulas - totaling about 6400 of these formulas.

Example - =IF(INDIRECT("'"&A91&"'!$C$18")<>"",10,"")

The reason for INDIRECT is that the cells A4:A150 contain an Index of the worksheets, which can constantly change...

My workbook has reached 98MB and I am struggling to find a way to streamline the process by which I pull back information to the front sheet.

Does anyone have any suggestions to a alternative for INDIRECT, or even a completely different approach?

(My problem is that the workbook tracks 'training' for a whole department (which is growing) and I know the workbook at such a large size already is only going to get slower and slower!)

Thanks in advance!