Accessing data from files with variable names

I am looking to pull data from various files that each have varaible names (they are saved by date) but fixed data locations and formats.

I am looking to run a macro which prompts you to open the required file, where the data range is already known.

This will be repeated to pull data from several diff locations.