Spreadsheet: 134498d1325341522-multiple-questions-to-be-asked-on-workbook-set-up-test311211
Sheet: COVER

JOB# |  |  | JOB NAME |  |  |  |  |  | CONTRACTOR |  |  |  |  |  |  |  |  | forum notes-                                                I wish to have excel automatically open a fresh panel worksheet whenever I enter a new panel in column D (magenta field), and pull the data entered from each respective worksheet and enter it in that sheet's row (green and blue feilds)
CUSTOMER CONTACT INFO |  |  |  |  |  |  |  | ENGINEER CONTACT INFO
 |  |  |  |  |  |  | NAME
 |  |  |  |  |  |  | PHONE
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | FAX
COMMENTS
JOB SUMMARY |  |  |  |  |  |  |  |  | CUBIC YDS |  | LBS |  | TONS |  | MAT. $
 |  |  |  |  |  |  |  |  | #N/A |  | #N/A |  | #N/A |  | #N/A
PANEL SUMMARY
STRUCTURE |  |  | PANEL # |  | WIDTH              feet         inches |  | HEIGHT          feet  inches |  | VOLUME           feet        yards |  | LBS |  | TONS |  | MAT. COST
 |  |  | panel 2 |  | 8 | 9 | 19 | 2.125 | 137.4357638888889 | 5.090213477366255 | 20615.36458333333 |  | 10.30768229166667 |  | 1918.024305555556
 |  |  | panel 1 |  | 10 | 9 | 9 | 8 | 56.38888888888889 | 2.088477366255144 | 8458.333333333332 |  | 4.229166666666666 |  | 852.3888888888889
 |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
0 |  |  | 0 |  |  |  |  |  | 0
JOB# |  |  | JOB NAME |  |  |  |  |  | CONTRACTOR
STRUCTURE |  |  | PANEL # |  | WIDTH              feet         inches |  | HEIGHT           feet inches |  | VOLUME           feet        yards |  | LBS |  | TONS |  | MAT. COST
RAW MATERIALS                                                                                                                                               PRICES SHOWN ARE IN NO WAY ACCURATE!!!
ITEM |  |  | $ PER |  | UNIT | ITEM |  |  | $ PER | UNIT | ITEM |  |  | $ PER | UNIT
# 3 REBAR |  |  | 1 |  | ft. | 1/2"X4" COIL LOOP |  |  | 2 | ea. | 5/8" WHEELS |  |  | 3 | ea.
# 4 REBAR |  |  | 1 |  | ft. | 1/2"X6" COIL LOOP |  |  | 2 | ea. | 1" STACK |  |  | 3 | ea.
# 5 REBAR |  |  | 1 |  | ft. | 1/2"X2" COIL BOLT |  |  | 2 | ea. | 1 1/2" STACK |  |  | 3 | ea.
# 6 REBAR |  |  | 1 |  | ft. | BOLT SPLICE-FLAT |  |  | 2 | ea. | 2" STACK |  |  | 3 | ea.
 |  |  |  |  |  | BOLT SPLICE-ANGLE |  |  | 2 | ea. | 2 1/2" STACK |  |  | 3 | ea.
 |  |  |  |  |  |  |  |  |  |  | 3" STACK |  |  | 3 | ea.
 |  |  |  |  |  |  |  |  |  |  | 2" F-CHAIR |  |  | 4 | ea.
 |  |  |  |  |  | 8X8 WELD PLATE |  |  | 5 | ea.
2T X 5 1/2" PINS |  |  | 1 |  | ea. | WELD SPLICE-FLAT |  |  | 5 | ea.
1T X 2 3/8" PINS |  |  | 1 |  | ea. | WELD SPLICE-ANGLE |  |  | 5 | ea. | CONCRETE |  |  | 10 | cu.ft.