Aggregate text files

Ok, so here goes. I have attached a sample workbook.

It doesn't produce data anything like the layout that is in your most recent workbook.
The reason for this is because it looks quite complex, and only you can really decide what data is supposed to go where.

My 'example' workbook has 2 worksheets, 'Summary' and 'User Input'.

The User Input worksheet is where you can have a list of items and the minimum qty's that you want to consider, as you described above.
When you run the 'Update' macro it will;
1) Look in the same directory as the Excel file is in for all text files that have a name of the correct format.
2) Determine the 'Newest' file for each of the Region / Item combinations.
3) Open each of those files, filter by the stationID's you gave, the minimum qtys given on the "User Input" sheet, and the 'bid' column.
4) Once the filters are applied it will then take the cheapest price, and place the information relating to this on the Summary Sheet.

If you step through the code you will be able to see how it is performing these actions.

Any questions please do ask. Hopefully this will show you enough for you to then be able to adapt the code to fit your spreadsheet.