Splitting date range into new roles and add other existing column data into the new roles

I have data in column A, B, C and D where column "C" is a start date and "D" is an end date. I'd like to split those dates into new rows and also add data from column A and B into each and every new role created. Please see sample excel file for reference. Any help with VBscript is greatly appreciated.

Thanks,

Ben

Thanks, Patel. I appreciate your help