Combining few excel data into one excel (in the specific format)

Hi, 

I have 5 excel data files (New Workers 1-4), which I would like to combine and extract relevant data and transfer it to the excel file (register-Test). How should I do it in power queries.

 

Thanks

Jenny