Concatenating multiple cells to a single cell between 2 tabs

Hey guys. I'm pretty new at VBA and macros as it is and I have a certain problem. The objective I’m aiming at is to copy the following information from the input excel sheet to the sheet 2 excel Tab in a specific format.
I have 5 columns (course, code, fee, year, avg) for 5 students in sheet 1. These are based on the enter and leave times. I want to to have either VBA code or macro that can concatenate the data in these columns into single cells in sheet 2 such that such that they are based on the time in the "enter" column in sheet 1 and arranged in this format: (course, code, avg, fee, year). I have attached the necessary document and provided an example for 1 cell in sheet 2.
Please assist me as I have no clue as to get around this. Thanks a bunch!