Excel Customer Auto-Fill Sheet

Here’s what I’m picturing:

Create a set of Building Inventory Forms for high-rise buildings using specifications dictated by the fire department.

1st on scene firefighters use them as a quick reference guide to locate specific areas and systems within the building during fire emergency operations.

We believe a portal using a stable platform like Excel would allow us to insert specific information on each building producing a clean crisp product we can edit, resulting in (4 completed master documents).

1.Stairwell / Elevator Elevation Diagram (Page 1)
2.Building Special Information Sheet (Page 2)
3.Standpipe Riser Diagram (Page 3)
4.Typical Floor Plan (Page 4)

Deliverables:
-The finished Excel file with the auto-fill logic in place, along with a brief set of instructions so I can add new customers or tweak fields without breaking the setup.

-Behind-the-scenes formulas or VBA that keep everything fast, accurate, and easy for a non-technical user to maintain.

-A clean set of (4) master, but scalable (1st floor up to 50 floors) excel documents we can add too or edit through input of information about the building, having it reflected in specific cells of document representing the (4 master documents).

I have uploaded a PDF providing specific examples of what they should look like as well as symbols for what the legends on each page should look like.

If there’s a smarter approach, we are open to suggestion as long as the core requirement of instant customer detail fill-in is met.