That sounds like a system that needs to be custom made for you. Might take a man-year or more, depending on the exact requirements and how 'luxury' the system would be.

An Excel guru might be able to make a complex (and probably unmaintainable) set of interrelated spreadsheets helping you with a lot of things, but personally I consider that to be misuse of Excel.