Copy data from raw to template based on 2 conditions

Hi all, good day!

I have monthly raw data of employees in tabular format.
Total of employees approximately 80 and each of them has a unique ID.

I am facing difficulties while trying to copy using macro:
1) My report users are used to a drop down list for selecting the employee that they want to view. However, the template is fixed. Intended result is data auto populated based on selected name from drop down.
2) I have blank rows ie the targeted range to be copied are not continuous in terms of row
3) The weekly total (see attached) is consists of Mon to Fri, thus the rows for date is not really fixed as I have to adjust for every begining of month. (In my sample I am assuming dec 1 as monday, i.e. starting day of the week)

Attached is a sample of my raw and intended result.
My actual raw and report would be in seperate sheets.

Appreciate any form of assistance.

Thank you very much.

hi, thank you for your reply.

i tried with functions, however, i will have a total of approximately 15000 rows for one month. i already tried using historical data and the file turned out to be very large. i did some experiments and found out that the cause was all the functions that i inserted in the template. i am hoping that i could use vba to minimize the use of function and hence minimizing the file size.

thank you very much for the effort and enlightenment!

I will give it a try now.

Will update should I encounter any difficulties.

Thank you!

HC