Import data from separate workbook, split and save into new files based on column value

Hey guys,

Hoping to get some guidance on how to write a macro that would allow someone to import a large data set organized by Column A and then have Excel split and save the relevant rows into files grouped by Column A identifier.