VBA code for importing data from external workbook(s) for a given header

[Adsup01]

Hello,

I am new to VBA code and need some assistance. I am looking to build a code that allows me to automate a data import based on corresponding titles/headers from various external workbooks. The external workbooks will not all have the same title either.

For instance:
I want to be able to select a document from desktop folder or My Docs folder, extract data from cells and rows and return to opened workbook under the corresponding header.

If this isn't possible, even to extract a predefined section of rows and cells (array) would be great.

The attached docs may help with my explanation.
I am looking to automate a data extract from external work book "Items" and return to cells in "Test VBA Data Extract" on sheet 'Results (1)' D5:D6500 if matching the title in cell D4.
The same can be said for E5:E6500 (iF matching E4) , F5;F6500 (If matching F4) and G5:G6500 (if matching G4)

Any help would be amazing.
Thank you

Test VBA DATA EXTRACT.xlsm
Items.xls