If you're going to dig a swimming pool, the question you ask shouldn't be
"How long to dig the pool with this spoon?" The question should be,
"What do I dig the hole with?"
Can what you're asking be done? Yes.
Should it be done in Excel? Probably not.
Forms implies creation of random documents... creation of a LOT of documents. To cull data from multiple and growing numbers of external documents, the spreadsheet you are using to gather the info would constantly require manual updating to accomplish this without macros. With macros... some complicated ones... the culling could happen.
Meanwhile, you should be using a different spoon... in this case a database of some kind. Forms created in a database are already connected and reports created against the data are much simpler because you're using the right tool.
I suspect the reason you want to use Excel is because you have it and are mildly experienced with it. Take it from someone who has done full programming projects within Excel... you will spend SO much time on this, in the end it is cheaper to:
- Hire someone to do it FOR you in Excel or
- Use a database program instead, even with the learning curve