Multiple Files Of Data To One Spreadsheet

I have about 7000 Excel files that I need condensed to one file. The data shown that I need in example one. In this example the data needed is in column B20 then B3-B19. My problem is the data in B20 is sometimes above or below.

In the other attached file(ExampleOutput) is how I am trying to get the data outputted.

Do you think that a macro/script con go thru all 7000 files automatically in a row to do this?

-Andy45898-08DH.xlsExampleOutput.xlsx

Yes, a macro could go through all the files automatically and do this...

I'd suggest uploading an example of the other type of file with B20 above/below and a description of the file/folder structure where the 7000 files are located.

Yes. I have a macro that can open all 7000 files, but I am unclear on what to do after it opens.
Open 45898-ohdh
get part# in B3. But B3 doesnt always have the part? It could be in B2 or somewhere else?
then store data from B4 thru b19 into the list format in Example output.

right?

Would you mind showing me how a script would look like withe the known data in the examples? I can't go thru all 7000 and get back to you in a timely manner

Please Login or Register  to view this content.

or something like that.

Ill try to run that. Ill let you know. Thanks very much!!

Please Login or Register  to view this content.

Is it possible to fill the file name in to a cell like maybe in column A