I tried to put it to my file. But it returns all the data from all other sheets. And does not return columns L, M, N and O in the summary.

And can it return the data in hidden cells also? Because I hide different columns in different sheets and in the summary columns don't fit.