Split table into multiple .csv files

Hello everyone.

I am trying to split a huge table, about 10k rows, into multiple .csv files. Each file must have only the header and the next row, also the names of each file should be a specific cell value, lets say "C2" of each .csv file for example.

Does excel do that? Do I need a macro for it?