Opening a text file copying a specific set of info for a list off numbers

Hi dflak,

thanks for replying and taking your time.

I have attached a few document.

1.) my workbook to sow you where I am currently sitting with my spreadsheet
2.) a word document explaining what I need more clearly
3.) zip folder containing Each part number folder and the retrospective MPF folder
4.) a txt file of my current macro.

Thanks again.