The result answering this question is the following: Suppose (M,F) is a foliation, with holonomy groupoid G = Hol(M,F). Let p: M --> G be the "quotient map from M to the leafspace" , with associated pullback p* from Sheaves(G) to sheaves on M. Suppose the holonomy cover of each leaf is n-connected. Then for any abelian sheaf A on M equipped with an action of the holonomy groupoid, i.e. for any object of Sheaves(G), the map p* induces isomorphisms in cohomology
H*(G,A) --> H*(M,p*A)
in degrees 0,...,n.

The proof is in fact not too hard, and surely much easier than what I did for the classifying space. It is a combination of some generalities for etale groupoids, and a similar fact for submersions between manifolds: If f: N --> M is a submersion with n-connected fibers, the f induces isomorphisms in cohomology in degrees up to n, for coefficients in any sheaf on M.

Ieke Moerdijk