I know that after a few searches Ive seen this done before but not quite how I am looking to do it..... That being said, I have multiple files that are layed out the same and I want to pull the data out of each file in that directory and import it so the data is cleaner.


For example: The files have the date in cell D4, I want that data to go into cell B2. The part number is in cell D5, I want that to go into cell C2

The data that I want to pull is all over the page and I just want to put all of it on 1 line per file that it looks at.

Thanks in advance!!