database - Multi-Line Excel to New Row Per Line -

i have large excel file, 5000 rows sample of upload here.

the file contains data employees following:

first column: employee name second: employee id columns 3-7:  experiences (multiline values) 3: career name 4: rank 5: 6: 7: reason leaving columns 8-13: managerial jobs columns 14-17: education columns 18-26: courses 

now each employee have many multi line values experiences, managerial jobs, education , courses, in other words, have many courses 1 @ each line on same row

now needed following: excel macro (vba):

1. to move every employee (row) header new worksheet in same workbook, , name sheet employee id located in column 2 (the code of ready)

2. for each multi line value (education example), should add each line in separate row

3. if possible sort every multiline values date, older newer. , thats it,

in attached excel file, i've made first employee, possible repeat operation 5000 employees, if not, database suggest use, can microsoft access it?

whilst excel can theoretically handle 5000 worksheets, not recommend creating such workbook.

even couple of hundred sheets, excel workbooks incredibly unwieldy. performance can issue navigation far greater one! few worksheets displayed in horizontal list @ bottom. possible, using vba, create menus specific sheets faster; still system far perfect.

it sounds access database better option here.

i suggest one table employees (this have ~5000 records) each employee has unique id. 'single line' fields such career name , rank go in here too.

then, have another table each 'multiple line' field, making use of foreign keys employees table.