Streamline attaching documnets to rows inside a single sheet.

We use a single sheet for a sequence a pieces to install on a project. Once we enter the information pertaining to each piece, each piece being its on row. Then we go through and attach a pdf of the piece drawing to its corresponding row. Is there a way to use a target folder which contains the piece drawings and then automate the pdf attachment based on the piece name column matching the document name?

Answers