Modify code to add column that pulls cell data from second workbook

[Bikeman]

Hello,
I have an existing workbook (PCN Test master Data.xlsm) that copies certain cells from many other workbooks. I知 trying to add one more column at the far right called (PCN Type). See column AN on attached (PCN Test master Data.xlsm). The data I want to enter in the column comes from the many different PCN痴 (See attached example PCN12345.xlsm) the cell highlighted in yellow (D13) is the one I知 trying to bring over to the master data workbook.

Note: There are two tabs at the bottom of the (PCN Test master Data.xlsm) workbook and both sheets need the (PCN Type) column added.

I did not create the (PCN Test master Data.xlsm) workbook so I知 having trouble understanding how to modify the code to bring in the info entered into cell D13. It uses many defined names which I知 unfamiliar with how they work.

See Attached workbooks!

Any help would be much appreciated!
Thanks, Bikeman