is it possible to collect (i.e. merge, consolidate, de-normalize, etc.) items from multiple nested document libraries on a site? My manager wants to flatten our MOSS 07 site's current nested hierarchical directory list structure and combine all items into a single, flat document library repository.
Anyway, I've been considering how this can be accomplished using, for example, the SPServices Javascript library, but I'm not sure if JS is the best approach for this kind of task. I also have Sharepoint Designer 2007 and VS 2010 dev tools at my disposal. From what I understand VS 2010 is not fully backward compatible with MOSS 2007 (please correct if I'm wrong), so it seems I basically just have SharePoint Designer 07 to work with along with MOSS 07's out-of-box tools.