I need a program that will allow me to automatically pull CSV files into a workbook from my Hardrive.

I need the ability to add the ticker symbols (maybe 400 in total)
and then hit a button and it then retrieves the specified spreadsheet from my hardrive and puts it into the Workbook.

Data entered in A2 -> Axxxx could change to any combination of letters.

Ticker
AAAE
AA
ALFA
ABVF
AACAF

I need each sheet to be labeled according to its ticker.

the sheets on the Hard drive are labeled according to their ticker above

Thanks