Importing Multiple Files into one spreadsheet

Hey guys,

So I have to import 300 files or so to update a price sheet so we can graph historical prices for something. I was hoping you could help me get the correct VBA/macro to import a folder full of the files that currently contain the old prices, and import a specific column/data from each file and have it transfer to a new sheet. Please let me know if this is possible! I've attached a dumbed down format of what one of the files I'd be extracting the prices from.

Any help would be greatly appreciated. Don't really know what I'll do if I can't get this to work hah.