Cory, Much better solution than my original suggestion. By placing the Content Query web part in each subsite, with the filtered views, it's very neat and tidy. You are correct on the caveat of uploading multiple documents. The inability to check in files automatically and add metadata upon upload...