Hi,
I have several sheets based on the dates requests are filled in. The workbook size increases with new days, as more sheets are added.
In each of these sheets, I have arrays referencing a mastersheet.
The formula is

"{=IF(INDEX('Sorted by Company'!B:K,MATCH(1,('Sorted by Company'!B:B=$A3)*('Sorted by Company'!E:E=$C3),0),10)="F","YES",IF(INDEX('Sorted by Company'!B:K,MATCH(1,('Sorted by Company'!B:B=$A3)*('Sorted by Company'!H:H=$F3),0),3)="C","YES",""))}"

But because there are so many arrays(Currently 25 sheets), and the workbook will continue to have even more worksheets added(sheets copied and deleted at the end of the month into other folders), it takes way too long to get new requests added to the Mastersheet. Any idea how I can convert this formula into VBA to speed up the process, as the current method is just too slow, I ended up having to stop the macro script and exit out of hte running code as it was just taking forever to load.