Report is crashing when I select multiple reports


I am attempting to run a report based on about 100 sheets all contained in one folder.

When I try to source the report across these sheets the report crashes before I can even add the columns.

If I try to add between about 1 and 10 source sheets it seems to work okay but when I add more it locks up and crashes.

Any advice? I've run reports on significantly more sheets in the past so I don't think thats the issue.