Form production which can be via a microsoft app or similar

We are a construction company based in the UK. I would like to design the following form types under one system/software:
Induction form for when first entering a construction site
Signing forms for daily contractors to use when they turn up and leave each site, these to record per site and also have a main data base of the records.
site audit forms
Snagging forms
If possible all the above to work off the same application. And have a management level so as key personal can update, then middle management can request data/records, with site staff being able to set up and manage at a local level.
I would like a facility that i can add additional forms onto.

also i would like to produce dash boards that show Financial KIPs in the office. We record most of these currently onto excel, but i want to have a visual update that can is easy to integrate and update. If possible with live information or by requesting data and updating