Automatic fill the timeline table from source

Hello Everyone,

i have some Project data with man power list schedule as per project
what i need to do is to look up the manpower list from the project data and translate it into timeline tables of manpower resources
the difficult thing is the list of the manpower is morethan one column and have no idea what kind of formula needed to get what i want

attached is my working sheet table with left table in the sheet 2 as working sheet and expected result in the right table



i still look for another job scheduler format, if you have another working sheet for job scheduler, that would be fantastic