New to the Forum - Automated Reports in Excel - Looking for Simple Solution

[planetb]

Hello Excel Gurus,

I am glad to be here. I am new to this forum and also to Excel. I am trying to explore this mysterious world of Excel and have just discovered that Macros can do wonders to day to day tedious jobs. I find it very fascinating but feel very restricted due to lack of skills. While I get more insight into this intricate world. I would like to request SMEs to help me solve this problem.
I have two Sheets, Sheet1 with employee data(listed below) and Sheet 2 is a report that gets generated for each employee that is listed in the sheet1 with the unique data elements for each employee in sheet1.(These data elements are highlighted in both sheets.)
Please provide some simple solution. Macro, Lookup, maybe something else.

Thanks. Appreciate any help. Look forward to the response.

Sheet1 and Sheet2 are attached.