Gotcha. Ok.

So the workbook is a template and is comprised of 9 worksheets. Its 1 workbook per project and a project can have 2 servers or 200+.
Tab 1 contains instructions to the users. Who is to fill out what and where.
Tab 2 : Server_provisioning tab (Range A-AF) Column AF (comments column) not required. The following required columns have pull-down selections to chose from (B,C,J,K,L,M,N,O,P,Q,R and S)
The server engineer will enter data from columns A through X only.
Server Name(A),Environment(B),Network Pod(C),IP Address Front(D),VLAN Front(E),IP Address Back(F)VLAN Back(G),IP Address Offnet(H),VLAN Offnet(I),Location(J),Model(K),Processor(L),Memory(M),Drives(N),Partition Carve (O),OS(P),Description(Q),SAN Attached?(R),Clustered?(S),Heartbeat (in IP format e.g. 192.168.x.y)(T),Application ID(U),Application Name(V),Application Owner(W),Application Owner Contact Number(X).
Then Saves and passes it to the Provisioning Eng.
Tab 2 - Server_Provisioning
The provisioning engineer will enter data from columns Y through AF only
DataCtr Floor Location (Y),Rack Location(Z),ILO Password(AA),Serial Number(AB) WWN(AC),Network Ports(AD),Storage Ports(AE), Comments(AF)
Tab 3: Infrastructure Cabling & SAN - Columns A-G - all populated from Tab 2 entries, except comments column G.
The following columns are autopopulated (from Tab 2 entries): server name, data center floor location, rack location, fabric switch, & fabric switch port for both A and B Fabrics.
Tab 4: Infrastructure Cabling & Network
The following columns are autopopulated: server name, data center floor location, rack location, fabric switch, & fabric switch port for both A and B Fabrics.
Tab 5: SAN Storage
The following columns are autopopulated: A-D) server name, rack location, WWN, & clustered. The SAN Storage engineer should complete the following fieldsE-K)
Fabric Switch A, Fabric Switch Port A, # of LUN, Tier, and Size

Tab 6: Firewall
The following columns (A-D) are autopopulated: source server name, environment, IP address back, VLAN back, The server engineer should complete the following fields: (E-I) Source IP address, Destination Server Name, Destination IP Address, URL/Domain Name, TCP/UDP Ports
Tab 7: Load Balancer
The server engineer is responsible for completing all of the columns associated with the Load Balancer tab.
Environment(A),DNS Name(B) VLAN(C)Network Layer(D),IP(E) Destination Servername 1(F),Destination IP 1(G),Destination Servername 2(H),Destination IP 2(I),Destination Servername 3(J),Destination IP 3(K),Destination Servername 4(L),Destination IP 4(M),Comments(N)
Tab 8: Monitoring
The following columns(A-G) are autopopulated: server name, environment, OS, application ID, application name, application owner, & application owner contact number.
The server engineer completes the custom rules (H),agent installed(I) and Monitoringh active? (J) fields.
H-J - and these have pull-down options.
The monitoring engineer confirms that the monitoring was installed and is active by completing the "Monitoring Active" field and closes the work order.
Tab 9: Back-up
The server engineer is responsible for completing all of the columns associated with the Back-up tab. Note: This tab is unique. I would probably need to re-work it or send it for you to see. The server engineer generates a work order to the back-up team for completion of this phase of the design document.
Much appreciated!