Exporting CSV Data to multiple tabs

Do you mean Excel? CSV itself is a generic format, that, while commonly opened automatically by Excel, is not a multi-tab spreadsheet format. Export to Excel instead. That can generate a tab for each dataset it is given.