google sheets expert chattanooga

We need a google sheets that will hold weekly data entered in by multiple apartment managers for multiple apartment complexes and storage complexes. I have attached a spreadsheet that we think will work but it needs to be modified to collect other data we need. The additional info sheet is the info we need incorperated into the sheet and dashboard. This also list the apartment and storage complexes. If possible we need a different dashboard for each complex then a single dashboard (1 for apartments and 1 for storage) that combines all the data from the individual dashboards. We are open to other idaes to get all this data into one place.