Im trying to insert BOM data AND custom properties data from an assembly drawing or part drawing into a premade excel template.  I have custom properties such as part number, revision, drawing number, and all BOM info in the drawing (such as item no, qty, part#, description) im trying to create a macro that will take that data and insert it into the proper locations in a premade template.  OR i would like the macro to make a new excel spreadsheet with the information populated after the file is created.

The document i am trying to populate is below (red arrows indicate what i would like populated)