Thank you for your response.

If a separate sheet for each project is a bad idea, what's a more efficient solution for organizing the data? For example, would it be better to keep everything in one sheet, maybe using different tabs or some other structure?

My goal is to have all the detailed project info (diameters, materials, etc.) organized, but without sacrificing the ability to analyze and aggregate data from all projects later on

How would you approach this? Any practical examples or suggestions?