I'm a contractor and i use an excel workbook with different sheets (please see attached). i've been making more and more changes to it. i want to be a to click the PO button and have it create a new sheet from my "PO template" sheet in the workbook. i also want it to pull the contractor name into the new sheet and then pull the contractor address and other info from my "contractor-owner list". i also want to eventually do the same with the change order button but once i figure the change order button then i can copy that info.
Vendor: (test contractor)
City: State: Zip Code: