I'm creating a Sharepoint Online site which stores our client documents. Currently, it's set up so there are three libraries (applications, performance, and misc.) and each document uploaded there has a column that identifies the client ID that it is associated with.
Ideally, what I'd like to do is have another site which has folders/libraries with each client ID as the title, and have a view that will reference the ID in the title and display all associated documents from across the other 3 libraries.
Is this feasible at all? If not, is it possible to have something (maybe a page) that the end user can input a client ID search/filter and have all the documents show up? I saw that it's possible using a content search web part, but I want to be able to filter by client name. I'm open to any ideas that would work, though.
The idea behind it is to store all similar documents in individual libraries, but be able to find all documents related to a client in a single place. I'm new to Sharepoint so I'm learning as I go along; thanks for your help!